<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<!-- NewPage -->
<html lang="en">
<head>
<title>XSSFCellStyle (POI API Documentation)</title>
<link rel="stylesheet" type="text/css" href="../../../../../stylesheet.css" title="Style">
</head>
<body>
<script type="text/javascript"><!--
    if (location.href.indexOf('is-external=true') == -1) {
        parent.document.title="XSSFCellStyle (POI API Documentation)";
    }
//-->
</script>
<noscript>
<div>JavaScript is disabled on your browser.</div>
</noscript>
<!-- ========= START OF TOP NAVBAR ======= -->
<div class="topNav"><a name="navbar_top">
<!--   -->
</a><a href="#skip-navbar_top" title="Skip navigation links"></a><a name="navbar_top_firstrow">
<!--   -->
</a>
<ul class="navList" title="Navigation">
<li><a href="../../../../../overview-summary.html">Overview</a></li>
<li><a href="package-summary.html">Package</a></li>
<li class="navBarCell1Rev">Class</li>
<li><a href="class-use/XSSFCellStyle.html">Use</a></li>
<li><a href="package-tree.html">Tree</a></li>
<li><a href="../../../../../deprecated-list.html">Deprecated</a></li>
<li><a href="../../../../../index-all.html">Index</a></li>
<li><a href="../../../../../help-doc.html">Help</a></li>
</ul>
</div>
<div class="subNav">
<ul class="navList">
<li><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFCell.html" title="class in org.apache.poi.xssf.usermodel"><span class="strong">PREV CLASS</span></a></li>
<li><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFChart.html" title="class in org.apache.poi.xssf.usermodel"><span class="strong">NEXT CLASS</span></a></li>
</ul>
<ul class="navList">
<li><a href="../../../../../index.html?org/apache/poi/xssf/usermodel/XSSFCellStyle.html" target="_top">FRAMES</a></li>
<li><a href="XSSFCellStyle.html" target="_top">NO FRAMES</a></li>
</ul>
<ul class="navList" id="allclasses_navbar_top">
<li><a href="../../../../../allclasses-noframe.html">All Classes</a></li>
</ul>
<div>
<script type="text/javascript"><!--
  allClassesLink = document.getElementById("allclasses_navbar_top");
  if(window==top) {
    allClassesLink.style.display = "block";
  }
  else {
    allClassesLink.style.display = "none";
  }
  //-->
</script>
</div>
<div>
<ul class="subNavList">
<li>SUMMARY:&nbsp;</li>
<li>NESTED&nbsp;|&nbsp;</li>
<li>FIELD&nbsp;|&nbsp;</li>
<li><a href="#constructor_summary">CONSTR</a>&nbsp;|&nbsp;</li>
<li><a href="#method_summary">METHOD</a></li>
</ul>
<ul class="subNavList">
<li>DETAIL:&nbsp;</li>
<li>FIELD&nbsp;|&nbsp;</li>
<li><a href="#constructor_detail">CONSTR</a>&nbsp;|&nbsp;</li>
<li><a href="#method_detail">METHOD</a></li>
</ul>
</div>
<a name="skip-navbar_top">
<!--   -->
</a></div>
<!-- ========= END OF TOP NAVBAR ========= -->
<!-- ======== START OF CLASS DATA ======== -->
<div class="header">
<p class="subTitle">org.apache.poi.xssf.usermodel</p>
<h2 title="Class XSSFCellStyle" class="title">Class XSSFCellStyle</h2>
</div>
<div class="contentContainer">
<ul class="inheritance">
<li>java.lang.Object</li>
<li>
<ul class="inheritance">
<li>org.apache.poi.xssf.usermodel.XSSFCellStyle</li>
</ul>
</li>
</ul>
<div class="description">
<ul class="blockList">
<li class="blockList">
<dl>
<dt>All Implemented Interfaces:</dt>
<dd><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html" title="interface in org.apache.poi.ss.usermodel">CellStyle</a></dd>
</dl>
<hr>
<br>
<pre>public class <strong>XSSFCellStyle</strong>
extends java.lang.Object
implements <a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html" title="interface in org.apache.poi.ss.usermodel">CellStyle</a></pre>
<div class="block">High level representation of the the possible formatting information for the contents of the cells on a sheet in a
 SpreadsheetML document.</div>
<dl><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#createCellStyle()"><code>XSSFWorkbook.createCellStyle()</code></a>, 
<a href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#getCellStyleAt(short)"><code>XSSFWorkbook.getCellStyleAt(short)</code></a>, 
<a href="../../../../../org/apache/poi/xssf/usermodel/XSSFCell.html#setCellStyle(org.apache.poi.ss.usermodel.CellStyle)"><code>XSSFCell.setCellStyle(org.apache.poi.ss.usermodel.CellStyle)</code></a></dd></dl>
</li>
</ul>
</div>
<div class="summary">
<ul class="blockList">
<li class="blockList">
<!-- =========== FIELD SUMMARY =========== -->
<ul class="blockList">
<li class="blockList"><a name="field_summary">
<!--   -->
</a>
<h3>Field Summary</h3>
<ul class="blockList">
<li class="blockList"><a name="fields_inherited_from_class_org.apache.poi.ss.usermodel.CellStyle">
<!--   -->
</a>
<h3>Fields inherited from interface&nbsp;org.apache.poi.ss.usermodel.<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html" title="interface in org.apache.poi.ss.usermodel">CellStyle</a></h3>
<code><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#ALIGN_CENTER">ALIGN_CENTER</a>, <a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#ALIGN_CENTER_SELECTION">ALIGN_CENTER_SELECTION</a>, <a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#ALIGN_FILL">ALIGN_FILL</a>, <a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#ALIGN_GENERAL">ALIGN_GENERAL</a>, <a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#ALIGN_JUSTIFY">ALIGN_JUSTIFY</a>, <a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#ALIGN_LEFT">ALIGN_LEFT</a>, <a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#ALIGN_RIGHT">ALIGN_RIGHT</a>, <a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#ALT_BARS">ALT_BARS</a>, <a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BIG_SPOTS">BIG_SPOTS</a>, <a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DASH_DOT">BORDER_DASH_DOT</a>, <a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DASH_DOT_DOT">BORDER_DASH_DOT_DOT</a>, <a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DASHED">BORDER_DASHED</a>, <a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DOTTED">BORDER_DOTTED</a>, <a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DOUBLE">BORDER_DOUBLE</a>, <a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_HAIR">BORDER_HAIR</a>, <a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_MEDIUM">BORDER_MEDIUM</a>, <a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_MEDIUM_DASH_DOT">BORDER_MEDIUM_DASH_DOT</a>, <a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_MEDIUM_DASH_DOT_DOT">BORDER_MEDIUM_DASH_DOT_DOT</a>, <a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_MEDIUM_DASHED">BORDER_MEDIUM_DASHED</a>, <a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_NONE">BORDER_NONE</a>, <a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_SLANTED_DASH_DOT">BORDER_SLANTED_DASH_DOT</a>, <a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_THICK">BORDER_THICK</a>, <a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_THIN">BORDER_THIN</a>, <a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BRICKS">BRICKS</a>, <a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#DIAMONDS">DIAMONDS</a>, <a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#FINE_DOTS">FINE_DOTS</a>, <a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#LEAST_DOTS">LEAST_DOTS</a>, <a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#LESS_DOTS">LESS_DOTS</a>, <a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#NO_FILL">NO_FILL</a>, <a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#SOLID_FOREGROUND">SOLID_FOREGROUND</a>, <a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#SPARSE_DOTS">SPARSE_DOTS</a>, <a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#SQUARES">SQUARES</a>, <a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#THICK_BACKWARD_DIAG">THICK_BACKWARD_DIAG</a>, <a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#THICK_FORWARD_DIAG">THICK_FORWARD_DIAG</a>, <a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#THICK_HORZ_BANDS">THICK_HORZ_BANDS</a>, <a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#THICK_VERT_BANDS">THICK_VERT_BANDS</a>, <a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#THIN_BACKWARD_DIAG">THIN_BACKWARD_DIAG</a>, <a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#THIN_FORWARD_DIAG">THIN_FORWARD_DIAG</a>, <a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#THIN_HORZ_BANDS">THIN_HORZ_BANDS</a>, <a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#THIN_VERT_BANDS">THIN_VERT_BANDS</a>, <a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#VERTICAL_BOTTOM">VERTICAL_BOTTOM</a>, <a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#VERTICAL_CENTER">VERTICAL_CENTER</a>, <a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#VERTICAL_JUSTIFY">VERTICAL_JUSTIFY</a>, <a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#VERTICAL_TOP">VERTICAL_TOP</a></code></li>
</ul>
</li>
</ul>
<!-- ======== CONSTRUCTOR SUMMARY ======== -->
<ul class="blockList">
<li class="blockList"><a name="constructor_summary">
<!--   -->
</a>
<h3>Constructor Summary</h3>
<table class="overviewSummary" border="0" cellpadding="3" cellspacing="0" summary="Constructor Summary table, listing constructors, and an explanation">
<caption><span>Constructors</span><span class="tabEnd">&nbsp;</span></caption>
<tr>
<th class="colOne" scope="col">Constructor and Description</th>
</tr>
<tr class="altColor">
<td class="colOne"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFCellStyle.html#XSSFCellStyle(int, int, org.apache.poi.xssf.model.StylesTable, org.apache.poi.xssf.model.ThemesTable)">XSSFCellStyle</a></strong>(int&nbsp;cellXfId,
             int&nbsp;cellStyleXfId,
             <a href="../../../../../org/apache/poi/xssf/model/StylesTable.html" title="class in org.apache.poi.xssf.model">StylesTable</a>&nbsp;stylesSource,
             <a href="../../../../../org/apache/poi/xssf/model/ThemesTable.html" title="class in org.apache.poi.xssf.model">ThemesTable</a>&nbsp;theme)</code>
<div class="block">Creates a Cell Style from the supplied parts</div>
</td>
</tr>
<tr class="rowColor">
<td class="colOne"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFCellStyle.html#XSSFCellStyle(org.apache.poi.xssf.model.StylesTable)">XSSFCellStyle</a></strong>(<a href="../../../../../org/apache/poi/xssf/model/StylesTable.html" title="class in org.apache.poi.xssf.model">StylesTable</a>&nbsp;stylesSource)</code>
<div class="block">Creates an empty Cell Style</div>
</td>
</tr>
</table>
</li>
</ul>
<!-- ========== METHOD SUMMARY =========== -->
<ul class="blockList">
<li class="blockList"><a name="method_summary">
<!--   -->
</a>
<h3>Method Summary</h3>
<table class="overviewSummary" border="0" cellpadding="3" cellspacing="0" summary="Method Summary table, listing methods, and an explanation">
<caption><span>Methods</span><span class="tabEnd">&nbsp;</span></caption>
<tr>
<th class="colFirst" scope="col">Modifier and Type</th>
<th class="colLast" scope="col">Method and Description</th>
</tr>
<tr class="altColor">
<td class="colFirst"><code>java.lang.Object</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFCellStyle.html#clone()">clone</a></strong>()</code>
<div class="block">Make a copy of this style.</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFCellStyle.html#cloneStyleFrom(org.apache.poi.ss.usermodel.CellStyle)">cloneStyleFrom</a></strong>(<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html" title="interface in org.apache.poi.ss.usermodel">CellStyle</a>&nbsp;source)</code>
<div class="block">Clones all the style information from another
  XSSFCellStyle, onto this one.</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>boolean</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFCellStyle.html#equals(java.lang.Object)">equals</a></strong>(java.lang.Object&nbsp;o)</code>
<div class="block">Checks is the supplied style is equal to this style</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>short</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFCellStyle.html#getAlignment()">getAlignment</a></strong>()</code>
<div class="block">Get the type of horizontal alignment for the cell</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code><a href="../../../../../org/apache/poi/ss/usermodel/HorizontalAlignment.html" title="enum in org.apache.poi.ss.usermodel">HorizontalAlignment</a></code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFCellStyle.html#getAlignmentEnum()">getAlignmentEnum</a></strong>()</code>
<div class="block">Get the type of horizontal alignment for the cell</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>short</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFCellStyle.html#getBorderBottom()">getBorderBottom</a></strong>()</code>
<div class="block">Get the type of border to use for the bottom border of the cell</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code><a href="../../../../../org/apache/poi/ss/usermodel/BorderStyle.html" title="enum in org.apache.poi.ss.usermodel">BorderStyle</a></code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFCellStyle.html#getBorderBottomEnum()">getBorderBottomEnum</a></strong>()</code>
<div class="block">Get the type of border to use for the bottom border of the cell</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFColor.html" title="class in org.apache.poi.xssf.usermodel">XSSFColor</a></code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFCellStyle.html#getBorderColor(org.apache.poi.xssf.usermodel.extensions.XSSFCellBorder.BorderSide)">getBorderColor</a></strong>(<a href="../../../../../org/apache/poi/xssf/usermodel/extensions/XSSFCellBorder.BorderSide.html" title="enum in org.apache.poi.xssf.usermodel.extensions">XSSFCellBorder.BorderSide</a>&nbsp;side)</code>
<div class="block">Gets border color</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>short</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFCellStyle.html#getBorderLeft()">getBorderLeft</a></strong>()</code>
<div class="block">Get the type of border to use for the left border of the cell</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code><a href="../../../../../org/apache/poi/ss/usermodel/BorderStyle.html" title="enum in org.apache.poi.ss.usermodel">BorderStyle</a></code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFCellStyle.html#getBorderLeftEnum()">getBorderLeftEnum</a></strong>()</code>
<div class="block">Get the type of border to use for the left border of the cell</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>short</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFCellStyle.html#getBorderRight()">getBorderRight</a></strong>()</code>
<div class="block">Get the type of border to use for the right border of the cell</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code><a href="../../../../../org/apache/poi/ss/usermodel/BorderStyle.html" title="enum in org.apache.poi.ss.usermodel">BorderStyle</a></code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFCellStyle.html#getBorderRightEnum()">getBorderRightEnum</a></strong>()</code>
<div class="block">Get the type of border to use for the right border of the cell</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>short</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFCellStyle.html#getBorderTop()">getBorderTop</a></strong>()</code>
<div class="block">Get the type of border to use for the top border of the cell</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code><a href="../../../../../org/apache/poi/ss/usermodel/BorderStyle.html" title="enum in org.apache.poi.ss.usermodel">BorderStyle</a></code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFCellStyle.html#getBorderTopEnum()">getBorderTopEnum</a></strong>()</code>
<div class="block">Get the type of border to use for the top border of the cell</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>short</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFCellStyle.html#getBottomBorderColor()">getBottomBorderColor</a></strong>()</code>
<div class="block">Get the color to use for the bottom border
 <br/>
 Color is optional.</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFColor.html" title="class in org.apache.poi.xssf.usermodel">XSSFColor</a></code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFCellStyle.html#getBottomBorderXSSFColor()">getBottomBorderXSSFColor</a></strong>()</code>
<div class="block">Get the color to use for the bottom border as a <a href="../../../../../org/apache/poi/xssf/usermodel/XSSFColor.html" title="class in org.apache.poi.xssf.usermodel"><code>XSSFColor</code></a></div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>protected <a href="../../../../../org/apache/poi/xssf/usermodel/extensions/XSSFCellAlignment.html" title="class in org.apache.poi.xssf.usermodel.extensions">XSSFCellAlignment</a></code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFCellStyle.html#getCellAlignment()">getCellAlignment</a></strong>()</code>
<div class="block">get the cellAlignment object to use for manage alignment</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>org.openxmlformats.schemas.spreadsheetml.x2006.main.CTXf</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFCellStyle.html#getCoreXf()">getCoreXf</a></strong>()</code>
<div class="block">Used so that StylesSource can figure out our location</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>short</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFCellStyle.html#getDataFormat()">getDataFormat</a></strong>()</code>
<div class="block">Get the index of the number format (numFmt) record used by this cell format.</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>java.lang.String</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFCellStyle.html#getDataFormatString()">getDataFormatString</a></strong>()</code>
<div class="block">Get the contents of the format string, by looking up
 the StylesSource</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>short</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFCellStyle.html#getFillBackgroundColor()">getFillBackgroundColor</a></strong>()</code>
<div class="block">Get the background fill color.</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFColor.html" title="class in org.apache.poi.xssf.usermodel">XSSFColor</a></code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFCellStyle.html#getFillBackgroundColorColor()">getFillBackgroundColorColor</a></strong>()</code>
<div class="block">Gets the color object representing the current
  background fill, resolving indexes using
  the supplied workbook.</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFColor.html" title="class in org.apache.poi.xssf.usermodel">XSSFColor</a></code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFCellStyle.html#getFillBackgroundXSSFColor()">getFillBackgroundXSSFColor</a></strong>()</code>
<div class="block">Get the background fill color.</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>short</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFCellStyle.html#getFillForegroundColor()">getFillForegroundColor</a></strong>()</code>
<div class="block">Get the foreground fill color.</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFColor.html" title="class in org.apache.poi.xssf.usermodel">XSSFColor</a></code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFCellStyle.html#getFillForegroundColorColor()">getFillForegroundColorColor</a></strong>()</code>
<div class="block">Gets the color object representing the current
  foreground fill, resolving indexes using
  the supplied workbook.</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFColor.html" title="class in org.apache.poi.xssf.usermodel">XSSFColor</a></code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFCellStyle.html#getFillForegroundXSSFColor()">getFillForegroundXSSFColor</a></strong>()</code>
<div class="block">Get the foreground fill color.</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>short</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFCellStyle.html#getFillPattern()">getFillPattern</a></strong>()</code>
<div class="block">Get the fill pattern</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code><a href="../../../../../org/apache/poi/ss/usermodel/FillPatternType.html" title="enum in org.apache.poi.ss.usermodel">FillPatternType</a></code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFCellStyle.html#getFillPatternEnum()">getFillPatternEnum</a></strong>()</code>
<div class="block">Get the fill pattern</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFFont.html" title="class in org.apache.poi.xssf.usermodel">XSSFFont</a></code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFCellStyle.html#getFont()">getFont</a></strong>()</code>
<div class="block">Gets the font for this style</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>short</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFCellStyle.html#getFontIndex()">getFontIndex</a></strong>()</code>
<div class="block">Gets the index of the font for this style</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>boolean</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFCellStyle.html#getHidden()">getHidden</a></strong>()</code>
<div class="block">Get whether the cell's using this style are to be hidden</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>short</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFCellStyle.html#getIndention()">getIndention</a></strong>()</code>
<div class="block">Get the number of spaces to indent the text in the cell</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>short</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFCellStyle.html#getIndex()">getIndex</a></strong>()</code>
<div class="block">Get the index within the StylesTable (sequence within the collection of CTXf elements)</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>short</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFCellStyle.html#getLeftBorderColor()">getLeftBorderColor</a></strong>()</code>
<div class="block">Get the color to use for the left border</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFColor.html" title="class in org.apache.poi.xssf.usermodel">XSSFColor</a></code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFCellStyle.html#getLeftBorderXSSFColor()">getLeftBorderXSSFColor</a></strong>()</code>
<div class="block">Get the color to use for the left border</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>boolean</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFCellStyle.html#getLocked()">getLocked</a></strong>()</code>
<div class="block">Get whether the cell's using this style are locked</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>short</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFCellStyle.html#getRightBorderColor()">getRightBorderColor</a></strong>()</code>
<div class="block">Get the color to use for the right border</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFColor.html" title="class in org.apache.poi.xssf.usermodel">XSSFColor</a></code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFCellStyle.html#getRightBorderXSSFColor()">getRightBorderXSSFColor</a></strong>()</code>
<div class="block">Get the color to use for the right border</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>short</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFCellStyle.html#getRotation()">getRotation</a></strong>()</code>
<div class="block">Get the degree of rotation for the text in the cell</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>boolean</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFCellStyle.html#getShrinkToFit()">getShrinkToFit</a></strong>()</code>
<div class="block">Should the Cell be auto-sized by Excel to shrink
  it to fit if this text is too long?</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>org.openxmlformats.schemas.spreadsheetml.x2006.main.CTXf</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFCellStyle.html#getStyleXf()">getStyleXf</a></strong>()</code>
<div class="block">Used so that StylesSource can figure out our location</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>short</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFCellStyle.html#getTopBorderColor()">getTopBorderColor</a></strong>()</code>
<div class="block">Get the color to use for the top border</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFColor.html" title="class in org.apache.poi.xssf.usermodel">XSSFColor</a></code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFCellStyle.html#getTopBorderXSSFColor()">getTopBorderXSSFColor</a></strong>()</code>
<div class="block">Get the color to use for the top border</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>short</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFCellStyle.html#getVerticalAlignment()">getVerticalAlignment</a></strong>()</code>
<div class="block">Get the type of vertical alignment for the cell</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code><a href="../../../../../org/apache/poi/ss/usermodel/VerticalAlignment.html" title="enum in org.apache.poi.ss.usermodel">VerticalAlignment</a></code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFCellStyle.html#getVerticalAlignmentEnum()">getVerticalAlignmentEnum</a></strong>()</code>
<div class="block">Get the type of vertical alignment for the cell</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>boolean</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFCellStyle.html#getWrapText()">getWrapText</a></strong>()</code>
<div class="block">Whether the text should be wrapped</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>int</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFCellStyle.html#hashCode()">hashCode</a></strong>()</code>
<div class="block">Returns a hash code value for the object.</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFCellStyle.html#setAlignment(org.apache.poi.ss.usermodel.HorizontalAlignment)">setAlignment</a></strong>(<a href="../../../../../org/apache/poi/ss/usermodel/HorizontalAlignment.html" title="enum in org.apache.poi.ss.usermodel">HorizontalAlignment</a>&nbsp;align)</code>
<div class="block">Set the type of horizontal alignment for the cell</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFCellStyle.html#setAlignment(short)">setAlignment</a></strong>(short&nbsp;align)</code>
<div class="block">Set the type of horizontal alignment for the cell</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFCellStyle.html#setBorderBottom(org.apache.poi.ss.usermodel.BorderStyle)">setBorderBottom</a></strong>(<a href="../../../../../org/apache/poi/ss/usermodel/BorderStyle.html" title="enum in org.apache.poi.ss.usermodel">BorderStyle</a>&nbsp;border)</code>
<div class="block">Set the type of border to use for the bottom border of the cell</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFCellStyle.html#setBorderBottom(short)">setBorderBottom</a></strong>(short&nbsp;border)</code>
<div class="block">Set the type of border to use for the bottom border of the cell</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFCellStyle.html#setBorderColor(org.apache.poi.xssf.usermodel.extensions.XSSFCellBorder.BorderSide, org.apache.poi.xssf.usermodel.XSSFColor)">setBorderColor</a></strong>(<a href="../../../../../org/apache/poi/xssf/usermodel/extensions/XSSFCellBorder.BorderSide.html" title="enum in org.apache.poi.xssf.usermodel.extensions">XSSFCellBorder.BorderSide</a>&nbsp;side,
              <a href="../../../../../org/apache/poi/xssf/usermodel/XSSFColor.html" title="class in org.apache.poi.xssf.usermodel">XSSFColor</a>&nbsp;color)</code>
<div class="block">Set the color to use for the selected border</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFCellStyle.html#setBorderLeft(org.apache.poi.ss.usermodel.BorderStyle)">setBorderLeft</a></strong>(<a href="../../../../../org/apache/poi/ss/usermodel/BorderStyle.html" title="enum in org.apache.poi.ss.usermodel">BorderStyle</a>&nbsp;border)</code>
<div class="block">Set the type of border to use for the left border of the cell</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFCellStyle.html#setBorderLeft(short)">setBorderLeft</a></strong>(short&nbsp;border)</code>
<div class="block">Set the type of border to use for the left border of the cell</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFCellStyle.html#setBorderRight(org.apache.poi.ss.usermodel.BorderStyle)">setBorderRight</a></strong>(<a href="../../../../../org/apache/poi/ss/usermodel/BorderStyle.html" title="enum in org.apache.poi.ss.usermodel">BorderStyle</a>&nbsp;border)</code>
<div class="block">Set the type of border to use for the right border of the cell</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFCellStyle.html#setBorderRight(short)">setBorderRight</a></strong>(short&nbsp;border)</code>
<div class="block">Set the type of border to use for the right border of the cell</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFCellStyle.html#setBorderTop(org.apache.poi.ss.usermodel.BorderStyle)">setBorderTop</a></strong>(<a href="../../../../../org/apache/poi/ss/usermodel/BorderStyle.html" title="enum in org.apache.poi.ss.usermodel">BorderStyle</a>&nbsp;border)</code>
<div class="block">Set the type of border to use for the top border of the cell</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFCellStyle.html#setBorderTop(short)">setBorderTop</a></strong>(short&nbsp;border)</code>
<div class="block">Set the type of border to use for the top border of the cell</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFCellStyle.html#setBottomBorderColor(short)">setBottomBorderColor</a></strong>(short&nbsp;color)</code>
<div class="block">Set the color to use for the bottom border</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFCellStyle.html#setBottomBorderColor(org.apache.poi.xssf.usermodel.XSSFColor)">setBottomBorderColor</a></strong>(<a href="../../../../../org/apache/poi/xssf/usermodel/XSSFColor.html" title="class in org.apache.poi.xssf.usermodel">XSSFColor</a>&nbsp;color)</code>
<div class="block">Set the color to use for the bottom border</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFCellStyle.html#setDataFormat(short)">setDataFormat</a></strong>(short&nbsp;fmt)</code>
<div class="block">Set the index of a data format</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFCellStyle.html#setFillBackgroundColor(short)">setFillBackgroundColor</a></strong>(short&nbsp;bg)</code>
<div class="block">Set the background fill color represented as a indexed color value.</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFCellStyle.html#setFillBackgroundColor(org.apache.poi.xssf.usermodel.XSSFColor)">setFillBackgroundColor</a></strong>(<a href="../../../../../org/apache/poi/xssf/usermodel/XSSFColor.html" title="class in org.apache.poi.xssf.usermodel">XSSFColor</a>&nbsp;color)</code>
<div class="block">Set the background fill color represented as a <a href="../../../../../org/apache/poi/xssf/usermodel/XSSFColor.html" title="class in org.apache.poi.xssf.usermodel"><code>XSSFColor</code></a> value.</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFCellStyle.html#setFillForegroundColor(short)">setFillForegroundColor</a></strong>(short&nbsp;fg)</code>
<div class="block">Set the foreground fill color as a indexed color value
 <br/>
 <i>Note: Ensure Foreground color is set prior to background color.</i></div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFCellStyle.html#setFillForegroundColor(org.apache.poi.xssf.usermodel.XSSFColor)">setFillForegroundColor</a></strong>(<a href="../../../../../org/apache/poi/xssf/usermodel/XSSFColor.html" title="class in org.apache.poi.xssf.usermodel">XSSFColor</a>&nbsp;color)</code>
<div class="block">Set the foreground fill color represented as a <a href="../../../../../org/apache/poi/xssf/usermodel/XSSFColor.html" title="class in org.apache.poi.xssf.usermodel"><code>XSSFColor</code></a> value.</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFCellStyle.html#setFillPattern(org.apache.poi.ss.usermodel.FillPatternType)">setFillPattern</a></strong>(<a href="../../../../../org/apache/poi/ss/usermodel/FillPatternType.html" title="enum in org.apache.poi.ss.usermodel">FillPatternType</a>&nbsp;ptrn)</code>
<div class="block">This element is used to specify cell fill information for pattern and solid color cell fills.</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFCellStyle.html#setFillPattern(short)">setFillPattern</a></strong>(short&nbsp;fp)</code>
<div class="block">This element is used to specify cell fill information for pattern and solid color cell fills.</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFCellStyle.html#setFont(org.apache.poi.ss.usermodel.Font)">setFont</a></strong>(<a href="../../../../../org/apache/poi/ss/usermodel/Font.html" title="interface in org.apache.poi.ss.usermodel">Font</a>&nbsp;font)</code>
<div class="block">Set the font for this style</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFCellStyle.html#setHidden(boolean)">setHidden</a></strong>(boolean&nbsp;hidden)</code>
<div class="block">Set the cell's using this style to be hidden</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFCellStyle.html#setIndention(short)">setIndention</a></strong>(short&nbsp;indent)</code>
<div class="block">Set the number of spaces to indent the text in the cell</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFCellStyle.html#setLeftBorderColor(short)">setLeftBorderColor</a></strong>(short&nbsp;color)</code>
<div class="block">Set the color to use for the left border as a indexed color value</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFCellStyle.html#setLeftBorderColor(org.apache.poi.xssf.usermodel.XSSFColor)">setLeftBorderColor</a></strong>(<a href="../../../../../org/apache/poi/xssf/usermodel/XSSFColor.html" title="class in org.apache.poi.xssf.usermodel">XSSFColor</a>&nbsp;color)</code>
<div class="block">Set the color to use for the left border as a <a href="../../../../../org/apache/poi/xssf/usermodel/XSSFColor.html" title="class in org.apache.poi.xssf.usermodel"><code>XSSFColor</code></a> value</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFCellStyle.html#setLocked(boolean)">setLocked</a></strong>(boolean&nbsp;locked)</code>
<div class="block">Set the cell's using this style to be locked</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFCellStyle.html#setRightBorderColor(short)">setRightBorderColor</a></strong>(short&nbsp;color)</code>
<div class="block">Set the color to use for the right border</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFCellStyle.html#setRightBorderColor(org.apache.poi.xssf.usermodel.XSSFColor)">setRightBorderColor</a></strong>(<a href="../../../../../org/apache/poi/xssf/usermodel/XSSFColor.html" title="class in org.apache.poi.xssf.usermodel">XSSFColor</a>&nbsp;color)</code>
<div class="block">Set the color to use for the right border as a <a href="../../../../../org/apache/poi/xssf/usermodel/XSSFColor.html" title="class in org.apache.poi.xssf.usermodel"><code>XSSFColor</code></a> value</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFCellStyle.html#setRotation(short)">setRotation</a></strong>(short&nbsp;rotation)</code>
<div class="block">Set the degree of rotation for the text in the cell</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFCellStyle.html#setShrinkToFit(boolean)">setShrinkToFit</a></strong>(boolean&nbsp;shrinkToFit)</code>
<div class="block">Controls if the Cell should be auto-sized
  to shrink to fit if the text is too long</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFCellStyle.html#setTopBorderColor(short)">setTopBorderColor</a></strong>(short&nbsp;color)</code>
<div class="block">Set the color to use for the top border</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFCellStyle.html#setTopBorderColor(org.apache.poi.xssf.usermodel.XSSFColor)">setTopBorderColor</a></strong>(<a href="../../../../../org/apache/poi/xssf/usermodel/XSSFColor.html" title="class in org.apache.poi.xssf.usermodel">XSSFColor</a>&nbsp;color)</code>
<div class="block">Set the color to use for the top border as a <a href="../../../../../org/apache/poi/xssf/usermodel/XSSFColor.html" title="class in org.apache.poi.xssf.usermodel"><code>XSSFColor</code></a> value</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFCellStyle.html#setVerticalAlignment(short)">setVerticalAlignment</a></strong>(short&nbsp;align)</code>
<div class="block">Set the type of vertical alignment for the cell</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFCellStyle.html#setVerticalAlignment(org.apache.poi.ss.usermodel.VerticalAlignment)">setVerticalAlignment</a></strong>(<a href="../../../../../org/apache/poi/ss/usermodel/VerticalAlignment.html" title="enum in org.apache.poi.ss.usermodel">VerticalAlignment</a>&nbsp;align)</code>
<div class="block">Set the type of vertical alignment for the cell</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFCellStyle.html#setWrapText(boolean)">setWrapText</a></strong>(boolean&nbsp;wrapped)</code>
<div class="block">Set whether the text should be wrapped.</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFCellStyle.html#verifyBelongsToStylesSource(org.apache.poi.xssf.model.StylesTable)">verifyBelongsToStylesSource</a></strong>(<a href="../../../../../org/apache/poi/xssf/model/StylesTable.html" title="class in org.apache.poi.xssf.model">StylesTable</a>&nbsp;src)</code>
<div class="block">Verifies that this style belongs to the supplied Workbook
  Styles Source.</div>
</td>
</tr>
</table>
<ul class="blockList">
<li class="blockList"><a name="methods_inherited_from_class_java.lang.Object">
<!--   -->
</a>
<h3>Methods inherited from class&nbsp;java.lang.Object</h3>
<code>finalize, getClass, notify, notifyAll, toString, wait, wait, wait</code></li>
</ul>
</li>
</ul>
</li>
</ul>
</div>
<div class="details">
<ul class="blockList">
<li class="blockList">
<!-- ========= CONSTRUCTOR DETAIL ======== -->
<ul class="blockList">
<li class="blockList"><a name="constructor_detail">
<!--   -->
</a>
<h3>Constructor Detail</h3>
<a name="XSSFCellStyle(int, int, org.apache.poi.xssf.model.StylesTable, org.apache.poi.xssf.model.ThemesTable)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>XSSFCellStyle</h4>
<pre>public&nbsp;XSSFCellStyle(int&nbsp;cellXfId,
             int&nbsp;cellStyleXfId,
             <a href="../../../../../org/apache/poi/xssf/model/StylesTable.html" title="class in org.apache.poi.xssf.model">StylesTable</a>&nbsp;stylesSource,
             <a href="../../../../../org/apache/poi/xssf/model/ThemesTable.html" title="class in org.apache.poi.xssf.model">ThemesTable</a>&nbsp;theme)</pre>
<div class="block">Creates a Cell Style from the supplied parts</div>
<dl><dt><span class="strong">Parameters:</span></dt><dd><code>cellXfId</code> - The main XF for the cell. Must be a valid 0-based index into the XF table</dd><dd><code>cellStyleXfId</code> - Optional, style xf. A value of <code>-1</code> means no xf.</dd><dd><code>stylesSource</code> - Styles Source to work off</dd></dl>
</li>
</ul>
<a name="XSSFCellStyle(org.apache.poi.xssf.model.StylesTable)">
<!--   -->
</a>
<ul class="blockListLast">
<li class="blockList">
<h4>XSSFCellStyle</h4>
<pre>public&nbsp;XSSFCellStyle(<a href="../../../../../org/apache/poi/xssf/model/StylesTable.html" title="class in org.apache.poi.xssf.model">StylesTable</a>&nbsp;stylesSource)</pre>
<div class="block">Creates an empty Cell Style</div>
</li>
</ul>
</li>
</ul>
<!-- ============ METHOD DETAIL ========== -->
<ul class="blockList">
<li class="blockList"><a name="method_detail">
<!--   -->
</a>
<h3>Method Detail</h3>
<a name="getCoreXf()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getCoreXf</h4>
<pre><a href="../../../../../org/apache/poi/util/Internal.html" title="annotation in org.apache.poi.util">@Internal</a>
public&nbsp;org.openxmlformats.schemas.spreadsheetml.x2006.main.CTXf&nbsp;getCoreXf()</pre>
<div class="block">Used so that StylesSource can figure out our location</div>
</li>
</ul>
<a name="getStyleXf()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getStyleXf</h4>
<pre><a href="../../../../../org/apache/poi/util/Internal.html" title="annotation in org.apache.poi.util">@Internal</a>
public&nbsp;org.openxmlformats.schemas.spreadsheetml.x2006.main.CTXf&nbsp;getStyleXf()</pre>
<div class="block">Used so that StylesSource can figure out our location</div>
</li>
</ul>
<a name="verifyBelongsToStylesSource(org.apache.poi.xssf.model.StylesTable)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>verifyBelongsToStylesSource</h4>
<pre>public&nbsp;void&nbsp;verifyBelongsToStylesSource(<a href="../../../../../org/apache/poi/xssf/model/StylesTable.html" title="class in org.apache.poi.xssf.model">StylesTable</a>&nbsp;src)</pre>
<div class="block">Verifies that this style belongs to the supplied Workbook
  Styles Source.
 Will throw an exception if it belongs to a different one.
 This is normally called when trying to assign a style to a
  cell, to ensure the cell and the style are from the same
  workbook (if they're not, it won't work)</div>
<dl><dt><span class="strong">Throws:</span></dt>
<dd><code>java.lang.IllegalArgumentException</code> - if there's a workbook mis-match</dd></dl>
</li>
</ul>
<a name="cloneStyleFrom(org.apache.poi.ss.usermodel.CellStyle)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>cloneStyleFrom</h4>
<pre>public&nbsp;void&nbsp;cloneStyleFrom(<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html" title="interface in org.apache.poi.ss.usermodel">CellStyle</a>&nbsp;source)</pre>
<div class="block">Clones all the style information from another
  XSSFCellStyle, onto this one. This
  XSSFCellStyle will then have all the same
  properties as the source, but the two may
  be edited independently.
 Any stylings on this XSSFCellStyle will be lost!

 The source XSSFCellStyle could be from another
  XSSFWorkbook if you like. This allows you to
  copy styles from one XSSFWorkbook to another.</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#cloneStyleFrom(org.apache.poi.ss.usermodel.CellStyle)">cloneStyleFrom</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html" title="interface in org.apache.poi.ss.usermodel">CellStyle</a></code></dd>
</dl>
</li>
</ul>
<a name="getAlignment()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getAlignment</h4>
<pre>public&nbsp;short&nbsp;getAlignment()</pre>
<div class="block">Get the type of horizontal alignment for the cell</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#getAlignment()">getAlignment</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html" title="interface in org.apache.poi.ss.usermodel">CellStyle</a></code></dd>
<dt><span class="strong">Returns:</span></dt><dd>short - the type of alignment</dd><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#ALIGN_GENERAL"><code>CellStyle.ALIGN_GENERAL</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#ALIGN_LEFT"><code>CellStyle.ALIGN_LEFT</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#ALIGN_CENTER"><code>CellStyle.ALIGN_CENTER</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#ALIGN_RIGHT"><code>CellStyle.ALIGN_RIGHT</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#ALIGN_FILL"><code>CellStyle.ALIGN_FILL</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#ALIGN_JUSTIFY"><code>CellStyle.ALIGN_JUSTIFY</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#ALIGN_CENTER_SELECTION"><code>CellStyle.ALIGN_CENTER_SELECTION</code></a></dd></dl>
</li>
</ul>
<a name="getAlignmentEnum()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getAlignmentEnum</h4>
<pre>public&nbsp;<a href="../../../../../org/apache/poi/ss/usermodel/HorizontalAlignment.html" title="enum in org.apache.poi.ss.usermodel">HorizontalAlignment</a>&nbsp;getAlignmentEnum()</pre>
<div class="block">Get the type of horizontal alignment for the cell</div>
<dl><dt><span class="strong">Returns:</span></dt><dd>HorizontalAlignment - the type of alignment</dd><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../org/apache/poi/ss/usermodel/HorizontalAlignment.html" title="enum in org.apache.poi.ss.usermodel"><code>HorizontalAlignment</code></a></dd></dl>
</li>
</ul>
<a name="getBorderBottom()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getBorderBottom</h4>
<pre>public&nbsp;short&nbsp;getBorderBottom()</pre>
<div class="block">Get the type of border to use for the bottom border of the cell</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#getBorderBottom()">getBorderBottom</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html" title="interface in org.apache.poi.ss.usermodel">CellStyle</a></code></dd>
<dt><span class="strong">Returns:</span></dt><dd>short - border type</dd><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_NONE"><code>CellStyle.BORDER_NONE</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_THIN"><code>CellStyle.BORDER_THIN</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_MEDIUM"><code>CellStyle.BORDER_MEDIUM</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DASHED"><code>CellStyle.BORDER_DASHED</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DOTTED"><code>CellStyle.BORDER_DOTTED</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_THICK"><code>CellStyle.BORDER_THICK</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DOUBLE"><code>CellStyle.BORDER_DOUBLE</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_HAIR"><code>CellStyle.BORDER_HAIR</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_MEDIUM_DASHED"><code>CellStyle.BORDER_MEDIUM_DASHED</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DASH_DOT"><code>CellStyle.BORDER_DASH_DOT</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_MEDIUM_DASH_DOT"><code>CellStyle.BORDER_MEDIUM_DASH_DOT</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DASH_DOT_DOT"><code>CellStyle.BORDER_DASH_DOT_DOT</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_MEDIUM_DASH_DOT_DOT"><code>CellStyle.BORDER_MEDIUM_DASH_DOT_DOT</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_SLANTED_DASH_DOT"><code>CellStyle.BORDER_SLANTED_DASH_DOT</code></a></dd></dl>
</li>
</ul>
<a name="getBorderBottomEnum()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getBorderBottomEnum</h4>
<pre>public&nbsp;<a href="../../../../../org/apache/poi/ss/usermodel/BorderStyle.html" title="enum in org.apache.poi.ss.usermodel">BorderStyle</a>&nbsp;getBorderBottomEnum()</pre>
<div class="block">Get the type of border to use for the bottom border of the cell</div>
<dl><dt><span class="strong">Returns:</span></dt><dd>border type as Java enum</dd><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../org/apache/poi/ss/usermodel/BorderStyle.html" title="enum in org.apache.poi.ss.usermodel"><code>BorderStyle</code></a></dd></dl>
</li>
</ul>
<a name="getBorderLeft()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getBorderLeft</h4>
<pre>public&nbsp;short&nbsp;getBorderLeft()</pre>
<div class="block">Get the type of border to use for the left border of the cell</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#getBorderLeft()">getBorderLeft</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html" title="interface in org.apache.poi.ss.usermodel">CellStyle</a></code></dd>
<dt><span class="strong">Returns:</span></dt><dd>short - border type, default value is <a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_NONE"><code>CellStyle.BORDER_NONE</code></a></dd><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_NONE"><code>CellStyle.BORDER_NONE</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_THIN"><code>CellStyle.BORDER_THIN</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_MEDIUM"><code>CellStyle.BORDER_MEDIUM</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DASHED"><code>CellStyle.BORDER_DASHED</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DOTTED"><code>CellStyle.BORDER_DOTTED</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_THICK"><code>CellStyle.BORDER_THICK</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DOUBLE"><code>CellStyle.BORDER_DOUBLE</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_HAIR"><code>CellStyle.BORDER_HAIR</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_MEDIUM_DASHED"><code>CellStyle.BORDER_MEDIUM_DASHED</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DASH_DOT"><code>CellStyle.BORDER_DASH_DOT</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_MEDIUM_DASH_DOT"><code>CellStyle.BORDER_MEDIUM_DASH_DOT</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DASH_DOT_DOT"><code>CellStyle.BORDER_DASH_DOT_DOT</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_MEDIUM_DASH_DOT_DOT"><code>CellStyle.BORDER_MEDIUM_DASH_DOT_DOT</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_SLANTED_DASH_DOT"><code>CellStyle.BORDER_SLANTED_DASH_DOT</code></a></dd></dl>
</li>
</ul>
<a name="getBorderLeftEnum()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getBorderLeftEnum</h4>
<pre>public&nbsp;<a href="../../../../../org/apache/poi/ss/usermodel/BorderStyle.html" title="enum in org.apache.poi.ss.usermodel">BorderStyle</a>&nbsp;getBorderLeftEnum()</pre>
<div class="block">Get the type of border to use for the left border of the cell</div>
<dl><dt><span class="strong">Returns:</span></dt><dd>border type, default value is <a href="../../../../../org/apache/poi/ss/usermodel/BorderStyle.html#NONE"><code>BorderStyle.NONE</code></a></dd></dl>
</li>
</ul>
<a name="getBorderRight()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getBorderRight</h4>
<pre>public&nbsp;short&nbsp;getBorderRight()</pre>
<div class="block">Get the type of border to use for the right border of the cell</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#getBorderRight()">getBorderRight</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html" title="interface in org.apache.poi.ss.usermodel">CellStyle</a></code></dd>
<dt><span class="strong">Returns:</span></dt><dd>short - border type, default value is <a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_NONE"><code>CellStyle.BORDER_NONE</code></a></dd><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_NONE"><code>CellStyle.BORDER_NONE</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_THIN"><code>CellStyle.BORDER_THIN</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_MEDIUM"><code>CellStyle.BORDER_MEDIUM</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DASHED"><code>CellStyle.BORDER_DASHED</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DOTTED"><code>CellStyle.BORDER_DOTTED</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_THICK"><code>CellStyle.BORDER_THICK</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DOUBLE"><code>CellStyle.BORDER_DOUBLE</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_HAIR"><code>CellStyle.BORDER_HAIR</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_MEDIUM_DASHED"><code>CellStyle.BORDER_MEDIUM_DASHED</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DASH_DOT"><code>CellStyle.BORDER_DASH_DOT</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_MEDIUM_DASH_DOT"><code>CellStyle.BORDER_MEDIUM_DASH_DOT</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DASH_DOT_DOT"><code>CellStyle.BORDER_DASH_DOT_DOT</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_MEDIUM_DASH_DOT_DOT"><code>CellStyle.BORDER_MEDIUM_DASH_DOT_DOT</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_SLANTED_DASH_DOT"><code>CellStyle.BORDER_SLANTED_DASH_DOT</code></a></dd></dl>
</li>
</ul>
<a name="getBorderRightEnum()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getBorderRightEnum</h4>
<pre>public&nbsp;<a href="../../../../../org/apache/poi/ss/usermodel/BorderStyle.html" title="enum in org.apache.poi.ss.usermodel">BorderStyle</a>&nbsp;getBorderRightEnum()</pre>
<div class="block">Get the type of border to use for the right border of the cell</div>
<dl><dt><span class="strong">Returns:</span></dt><dd>border type, default value is <a href="../../../../../org/apache/poi/ss/usermodel/BorderStyle.html#NONE"><code>BorderStyle.NONE</code></a></dd></dl>
</li>
</ul>
<a name="getBorderTop()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getBorderTop</h4>
<pre>public&nbsp;short&nbsp;getBorderTop()</pre>
<div class="block">Get the type of border to use for the top border of the cell</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#getBorderTop()">getBorderTop</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html" title="interface in org.apache.poi.ss.usermodel">CellStyle</a></code></dd>
<dt><span class="strong">Returns:</span></dt><dd>short - border type, default value is <a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_NONE"><code>CellStyle.BORDER_NONE</code></a></dd><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_NONE"><code>CellStyle.BORDER_NONE</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_THIN"><code>CellStyle.BORDER_THIN</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_MEDIUM"><code>CellStyle.BORDER_MEDIUM</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DASHED"><code>CellStyle.BORDER_DASHED</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DOTTED"><code>CellStyle.BORDER_DOTTED</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html" title="interface in org.apache.poi.ss.usermodel"><code>#BORDER_THICK</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DOUBLE"><code>CellStyle.BORDER_DOUBLE</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_HAIR"><code>CellStyle.BORDER_HAIR</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_MEDIUM_DASHED"><code>CellStyle.BORDER_MEDIUM_DASHED</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DASH_DOT"><code>CellStyle.BORDER_DASH_DOT</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_MEDIUM_DASH_DOT"><code>CellStyle.BORDER_MEDIUM_DASH_DOT</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DASH_DOT_DOT"><code>CellStyle.BORDER_DASH_DOT_DOT</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_MEDIUM_DASH_DOT_DOT"><code>CellStyle.BORDER_MEDIUM_DASH_DOT_DOT</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_SLANTED_DASH_DOT"><code>CellStyle.BORDER_SLANTED_DASH_DOT</code></a></dd></dl>
</li>
</ul>
<a name="getBorderTopEnum()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getBorderTopEnum</h4>
<pre>public&nbsp;<a href="../../../../../org/apache/poi/ss/usermodel/BorderStyle.html" title="enum in org.apache.poi.ss.usermodel">BorderStyle</a>&nbsp;getBorderTopEnum()</pre>
<div class="block">Get the type of border to use for the top border of the cell</div>
<dl><dt><span class="strong">Returns:</span></dt><dd>border type, default value is <a href="../../../../../org/apache/poi/ss/usermodel/BorderStyle.html#NONE"><code>BorderStyle.NONE</code></a></dd></dl>
</li>
</ul>
<a name="getBottomBorderColor()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getBottomBorderColor</h4>
<pre>public&nbsp;short&nbsp;getBottomBorderColor()</pre>
<div class="block">Get the color to use for the bottom border
 <br/>
 Color is optional. When missing, IndexedColors.AUTOMATIC is implied.</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#getBottomBorderColor()">getBottomBorderColor</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html" title="interface in org.apache.poi.ss.usermodel">CellStyle</a></code></dd>
<dt><span class="strong">Returns:</span></dt><dd>the index of the color definition, default value is <a href="../../../../../org/apache/poi/ss/usermodel/IndexedColors.html#AUTOMATIC"><code>IndexedColors.AUTOMATIC</code></a></dd><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../org/apache/poi/ss/usermodel/IndexedColors.html" title="enum in org.apache.poi.ss.usermodel"><code>IndexedColors</code></a></dd></dl>
</li>
</ul>
<a name="getBottomBorderXSSFColor()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getBottomBorderXSSFColor</h4>
<pre>public&nbsp;<a href="../../../../../org/apache/poi/xssf/usermodel/XSSFColor.html" title="class in org.apache.poi.xssf.usermodel">XSSFColor</a>&nbsp;getBottomBorderXSSFColor()</pre>
<div class="block">Get the color to use for the bottom border as a <a href="../../../../../org/apache/poi/xssf/usermodel/XSSFColor.html" title="class in org.apache.poi.xssf.usermodel"><code>XSSFColor</code></a></div>
<dl><dt><span class="strong">Returns:</span></dt><dd>the used color or <code>null</code> if not set</dd></dl>
</li>
</ul>
<a name="getDataFormat()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getDataFormat</h4>
<pre>public&nbsp;short&nbsp;getDataFormat()</pre>
<div class="block">Get the index of the number format (numFmt) record used by this cell format.</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#getDataFormat()">getDataFormat</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html" title="interface in org.apache.poi.ss.usermodel">CellStyle</a></code></dd>
<dt><span class="strong">Returns:</span></dt><dd>the index of the number format</dd><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../org/apache/poi/ss/usermodel/DataFormat.html" title="interface in org.apache.poi.ss.usermodel"><code>DataFormat</code></a></dd></dl>
</li>
</ul>
<a name="getDataFormatString()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getDataFormatString</h4>
<pre>public&nbsp;java.lang.String&nbsp;getDataFormatString()</pre>
<div class="block">Get the contents of the format string, by looking up
 the StylesSource</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#getDataFormatString()">getDataFormatString</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html" title="interface in org.apache.poi.ss.usermodel">CellStyle</a></code></dd>
<dt><span class="strong">Returns:</span></dt><dd>the number format string</dd></dl>
</li>
</ul>
<a name="getFillBackgroundColor()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getFillBackgroundColor</h4>
<pre>public&nbsp;short&nbsp;getFillBackgroundColor()</pre>
<div class="block">Get the background fill color.
 <p>
 Note - many cells are actually filled with a foreground
  fill, not a background fill - see <a href="../../../../../org/apache/poi/xssf/usermodel/XSSFCellStyle.html#getFillForegroundColor()"><code>getFillForegroundColor()</code></a>
 </p></div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#getFillBackgroundColor()">getFillBackgroundColor</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html" title="interface in org.apache.poi.ss.usermodel">CellStyle</a></code></dd>
<dt><span class="strong">Returns:</span></dt><dd>fill color, default value is <a href="../../../../../org/apache/poi/ss/usermodel/IndexedColors.html#AUTOMATIC"><code>IndexedColors.AUTOMATIC</code></a></dd><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../org/apache/poi/ss/usermodel/IndexedColors.html" title="enum in org.apache.poi.ss.usermodel"><code>IndexedColors</code></a></dd></dl>
</li>
</ul>
<a name="getFillBackgroundColorColor()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getFillBackgroundColorColor</h4>
<pre>public&nbsp;<a href="../../../../../org/apache/poi/xssf/usermodel/XSSFColor.html" title="class in org.apache.poi.xssf.usermodel">XSSFColor</a>&nbsp;getFillBackgroundColorColor()</pre>
<div class="block"><strong>Description copied from interface:&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#getFillBackgroundColorColor()">CellStyle</a></code></strong></div>
<div class="block">Gets the color object representing the current
  background fill, resolving indexes using
  the supplied workbook.
 This will work for both indexed and rgb
  defined colors.</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#getFillBackgroundColorColor()">getFillBackgroundColorColor</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html" title="interface in org.apache.poi.ss.usermodel">CellStyle</a></code></dd>
</dl>
</li>
</ul>
<a name="getFillBackgroundXSSFColor()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getFillBackgroundXSSFColor</h4>
<pre>public&nbsp;<a href="../../../../../org/apache/poi/xssf/usermodel/XSSFColor.html" title="class in org.apache.poi.xssf.usermodel">XSSFColor</a>&nbsp;getFillBackgroundXSSFColor()</pre>
<div class="block">Get the background fill color.
 <p>
 Note - many cells are actually filled with a foreground
  fill, not a background fill - see <a href="../../../../../org/apache/poi/xssf/usermodel/XSSFCellStyle.html#getFillForegroundColor()"><code>getFillForegroundColor()</code></a>
 </p></div>
<dl><dt><span class="strong">Returns:</span></dt><dd>XSSFColor - fill color or <code>null</code> if not set</dd><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFColor.html#getRgb()"><code>XSSFColor.getRgb()</code></a></dd></dl>
</li>
</ul>
<a name="getFillForegroundColor()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getFillForegroundColor</h4>
<pre>public&nbsp;short&nbsp;getFillForegroundColor()</pre>
<div class="block">Get the foreground fill color.
 <p>
 Many cells are filled with this, instead of a
  background color (<a href="../../../../../org/apache/poi/xssf/usermodel/XSSFCellStyle.html#getFillBackgroundColor()"><code>getFillBackgroundColor()</code></a>)
 </p></div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#getFillForegroundColor()">getFillForegroundColor</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html" title="interface in org.apache.poi.ss.usermodel">CellStyle</a></code></dd>
<dt><span class="strong">Returns:</span></dt><dd>fill color, default value is <a href="../../../../../org/apache/poi/ss/usermodel/IndexedColors.html#AUTOMATIC"><code>IndexedColors.AUTOMATIC</code></a></dd><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../org/apache/poi/ss/usermodel/IndexedColors.html" title="enum in org.apache.poi.ss.usermodel"><code>IndexedColors</code></a></dd></dl>
</li>
</ul>
<a name="getFillForegroundColorColor()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getFillForegroundColorColor</h4>
<pre>public&nbsp;<a href="../../../../../org/apache/poi/xssf/usermodel/XSSFColor.html" title="class in org.apache.poi.xssf.usermodel">XSSFColor</a>&nbsp;getFillForegroundColorColor()</pre>
<div class="block"><strong>Description copied from interface:&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#getFillForegroundColorColor()">CellStyle</a></code></strong></div>
<div class="block">Gets the color object representing the current
  foreground fill, resolving indexes using
  the supplied workbook.
 This will work for both indexed and rgb
  defined colors.</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#getFillForegroundColorColor()">getFillForegroundColorColor</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html" title="interface in org.apache.poi.ss.usermodel">CellStyle</a></code></dd>
</dl>
</li>
</ul>
<a name="getFillForegroundXSSFColor()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getFillForegroundXSSFColor</h4>
<pre>public&nbsp;<a href="../../../../../org/apache/poi/xssf/usermodel/XSSFColor.html" title="class in org.apache.poi.xssf.usermodel">XSSFColor</a>&nbsp;getFillForegroundXSSFColor()</pre>
<div class="block">Get the foreground fill color.</div>
<dl><dt><span class="strong">Returns:</span></dt><dd>XSSFColor - fill color or <code>null</code> if not set</dd></dl>
</li>
</ul>
<a name="getFillPattern()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getFillPattern</h4>
<pre>public&nbsp;short&nbsp;getFillPattern()</pre>
<div class="block">Get the fill pattern</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#getFillPattern()">getFillPattern</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html" title="interface in org.apache.poi.ss.usermodel">CellStyle</a></code></dd>
<dt><span class="strong">Returns:</span></dt><dd>fill pattern, default value is <a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#NO_FILL"><code>CellStyle.NO_FILL</code></a></dd><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#NO_FILL"><code>CellStyle.NO_FILL</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#SOLID_FOREGROUND"><code>CellStyle.SOLID_FOREGROUND</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#FINE_DOTS"><code>CellStyle.FINE_DOTS</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#ALT_BARS"><code>CellStyle.ALT_BARS</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#SPARSE_DOTS"><code>CellStyle.SPARSE_DOTS</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#THICK_HORZ_BANDS"><code>CellStyle.THICK_HORZ_BANDS</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#THICK_VERT_BANDS"><code>CellStyle.THICK_VERT_BANDS</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#THICK_BACKWARD_DIAG"><code>CellStyle.THICK_BACKWARD_DIAG</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#THICK_FORWARD_DIAG"><code>CellStyle.THICK_FORWARD_DIAG</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BIG_SPOTS"><code>CellStyle.BIG_SPOTS</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BRICKS"><code>CellStyle.BRICKS</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#THIN_HORZ_BANDS"><code>CellStyle.THIN_HORZ_BANDS</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#THIN_VERT_BANDS"><code>CellStyle.THIN_VERT_BANDS</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#THIN_BACKWARD_DIAG"><code>CellStyle.THIN_BACKWARD_DIAG</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#THIN_FORWARD_DIAG"><code>CellStyle.THIN_FORWARD_DIAG</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#SQUARES"><code>CellStyle.SQUARES</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#DIAMONDS"><code>CellStyle.DIAMONDS</code></a></dd></dl>
</li>
</ul>
<a name="getFillPatternEnum()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getFillPatternEnum</h4>
<pre>public&nbsp;<a href="../../../../../org/apache/poi/ss/usermodel/FillPatternType.html" title="enum in org.apache.poi.ss.usermodel">FillPatternType</a>&nbsp;getFillPatternEnum()</pre>
<div class="block">Get the fill pattern</div>
<dl><dt><span class="strong">Returns:</span></dt><dd>the fill pattern, default value is <a href="../../../../../org/apache/poi/ss/usermodel/FillPatternType.html#NO_FILL"><code>FillPatternType.NO_FILL</code></a></dd></dl>
</li>
</ul>
<a name="getFont()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getFont</h4>
<pre>public&nbsp;<a href="../../../../../org/apache/poi/xssf/usermodel/XSSFFont.html" title="class in org.apache.poi.xssf.usermodel">XSSFFont</a>&nbsp;getFont()</pre>
<div class="block">Gets the font for this style</div>
<dl><dt><span class="strong">Returns:</span></dt><dd>Font - font</dd></dl>
</li>
</ul>
<a name="getFontIndex()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getFontIndex</h4>
<pre>public&nbsp;short&nbsp;getFontIndex()</pre>
<div class="block">Gets the index of the font for this style</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#getFontIndex()">getFontIndex</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html" title="interface in org.apache.poi.ss.usermodel">CellStyle</a></code></dd>
<dt><span class="strong">Returns:</span></dt><dd>short - font index</dd><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#getFontAt(short)"><code>XSSFWorkbook.getFontAt(short)</code></a></dd></dl>
</li>
</ul>
<a name="getHidden()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getHidden</h4>
<pre>public&nbsp;boolean&nbsp;getHidden()</pre>
<div class="block">Get whether the cell's using this style are to be hidden</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#getHidden()">getHidden</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html" title="interface in org.apache.poi.ss.usermodel">CellStyle</a></code></dd>
<dt><span class="strong">Returns:</span></dt><dd>boolean -  whether the cell using this style is hidden</dd></dl>
</li>
</ul>
<a name="getIndention()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getIndention</h4>
<pre>public&nbsp;short&nbsp;getIndention()</pre>
<div class="block">Get the number of spaces to indent the text in the cell</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#getIndention()">getIndention</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html" title="interface in org.apache.poi.ss.usermodel">CellStyle</a></code></dd>
<dt><span class="strong">Returns:</span></dt><dd>indent - number of spaces</dd></dl>
</li>
</ul>
<a name="getIndex()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getIndex</h4>
<pre>public&nbsp;short&nbsp;getIndex()</pre>
<div class="block">Get the index within the StylesTable (sequence within the collection of CTXf elements)</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#getIndex()">getIndex</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html" title="interface in org.apache.poi.ss.usermodel">CellStyle</a></code></dd>
<dt><span class="strong">Returns:</span></dt><dd>unique index number of the underlying record this style represents</dd></dl>
</li>
</ul>
<a name="getLeftBorderColor()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getLeftBorderColor</h4>
<pre>public&nbsp;short&nbsp;getLeftBorderColor()</pre>
<div class="block">Get the color to use for the left border</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#getLeftBorderColor()">getLeftBorderColor</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html" title="interface in org.apache.poi.ss.usermodel">CellStyle</a></code></dd>
<dt><span class="strong">Returns:</span></dt><dd>the index of the color definition, default value is <a href="../../../../../org/apache/poi/ss/usermodel/IndexedColors.html#BLACK"><code>IndexedColors.BLACK</code></a></dd><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../org/apache/poi/ss/usermodel/IndexedColors.html" title="enum in org.apache.poi.ss.usermodel"><code>IndexedColors</code></a></dd></dl>
</li>
</ul>
<a name="getLeftBorderXSSFColor()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getLeftBorderXSSFColor</h4>
<pre>public&nbsp;<a href="../../../../../org/apache/poi/xssf/usermodel/XSSFColor.html" title="class in org.apache.poi.xssf.usermodel">XSSFColor</a>&nbsp;getLeftBorderXSSFColor()</pre>
<div class="block">Get the color to use for the left border</div>
<dl><dt><span class="strong">Returns:</span></dt><dd>the index of the color definition or <code>null</code> if not set</dd><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../org/apache/poi/ss/usermodel/IndexedColors.html" title="enum in org.apache.poi.ss.usermodel"><code>IndexedColors</code></a></dd></dl>
</li>
</ul>
<a name="getLocked()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getLocked</h4>
<pre>public&nbsp;boolean&nbsp;getLocked()</pre>
<div class="block">Get whether the cell's using this style are locked</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#getLocked()">getLocked</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html" title="interface in org.apache.poi.ss.usermodel">CellStyle</a></code></dd>
<dt><span class="strong">Returns:</span></dt><dd>whether the cell using this style are locked</dd></dl>
</li>
</ul>
<a name="getRightBorderColor()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getRightBorderColor</h4>
<pre>public&nbsp;short&nbsp;getRightBorderColor()</pre>
<div class="block">Get the color to use for the right border</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#getRightBorderColor()">getRightBorderColor</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html" title="interface in org.apache.poi.ss.usermodel">CellStyle</a></code></dd>
<dt><span class="strong">Returns:</span></dt><dd>the index of the color definition, default value is <a href="../../../../../org/apache/poi/ss/usermodel/IndexedColors.html#BLACK"><code>IndexedColors.BLACK</code></a></dd><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../org/apache/poi/ss/usermodel/IndexedColors.html" title="enum in org.apache.poi.ss.usermodel"><code>IndexedColors</code></a></dd></dl>
</li>
</ul>
<a name="getRightBorderXSSFColor()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getRightBorderXSSFColor</h4>
<pre>public&nbsp;<a href="../../../../../org/apache/poi/xssf/usermodel/XSSFColor.html" title="class in org.apache.poi.xssf.usermodel">XSSFColor</a>&nbsp;getRightBorderXSSFColor()</pre>
<div class="block">Get the color to use for the right border</div>
<dl><dt><span class="strong">Returns:</span></dt><dd>the used color or <code>null</code> if not set</dd></dl>
</li>
</ul>
<a name="getRotation()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getRotation</h4>
<pre>public&nbsp;short&nbsp;getRotation()</pre>
<div class="block">Get the degree of rotation for the text in the cell
 <p>
 Expressed in degrees. Values range from 0 to 180. The first letter of
 the text is considered the center-point of the arc.
 <br/>
 For 0 - 90, the value represents degrees above horizon. For 91-180 the degrees below the
 horizon is calculated as:
 <br/>
 <code>[degrees below horizon] = 90 - textRotation.</code>
 </p></div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#getRotation()">getRotation</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html" title="interface in org.apache.poi.ss.usermodel">CellStyle</a></code></dd>
<dt><span class="strong">Returns:</span></dt><dd>rotation degrees (between 0 and 180 degrees)</dd></dl>
</li>
</ul>
<a name="getShrinkToFit()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getShrinkToFit</h4>
<pre>public&nbsp;boolean&nbsp;getShrinkToFit()</pre>
<div class="block"><strong>Description copied from interface:&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#getShrinkToFit()">CellStyle</a></code></strong></div>
<div class="block">Should the Cell be auto-sized by Excel to shrink
  it to fit if this text is too long?</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#getShrinkToFit()">getShrinkToFit</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html" title="interface in org.apache.poi.ss.usermodel">CellStyle</a></code></dd>
</dl>
</li>
</ul>
<a name="getTopBorderColor()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getTopBorderColor</h4>
<pre>public&nbsp;short&nbsp;getTopBorderColor()</pre>
<div class="block">Get the color to use for the top border</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#getTopBorderColor()">getTopBorderColor</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html" title="interface in org.apache.poi.ss.usermodel">CellStyle</a></code></dd>
<dt><span class="strong">Returns:</span></dt><dd>the index of the color definition, default value is <a href="../../../../../org/apache/poi/ss/usermodel/IndexedColors.html#BLACK"><code>IndexedColors.BLACK</code></a></dd><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../org/apache/poi/ss/usermodel/IndexedColors.html" title="enum in org.apache.poi.ss.usermodel"><code>IndexedColors</code></a></dd></dl>
</li>
</ul>
<a name="getTopBorderXSSFColor()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getTopBorderXSSFColor</h4>
<pre>public&nbsp;<a href="../../../../../org/apache/poi/xssf/usermodel/XSSFColor.html" title="class in org.apache.poi.xssf.usermodel">XSSFColor</a>&nbsp;getTopBorderXSSFColor()</pre>
<div class="block">Get the color to use for the top border</div>
<dl><dt><span class="strong">Returns:</span></dt><dd>the used color or <code>null</code> if not set</dd></dl>
</li>
</ul>
<a name="getVerticalAlignment()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getVerticalAlignment</h4>
<pre>public&nbsp;short&nbsp;getVerticalAlignment()</pre>
<div class="block">Get the type of vertical alignment for the cell</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#getVerticalAlignment()">getVerticalAlignment</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html" title="interface in org.apache.poi.ss.usermodel">CellStyle</a></code></dd>
<dt><span class="strong">Returns:</span></dt><dd>align the type of alignment, default value is <a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#VERTICAL_BOTTOM"><code>CellStyle.VERTICAL_BOTTOM</code></a></dd><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#VERTICAL_TOP"><code>CellStyle.VERTICAL_TOP</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#VERTICAL_CENTER"><code>CellStyle.VERTICAL_CENTER</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#VERTICAL_BOTTOM"><code>CellStyle.VERTICAL_BOTTOM</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#VERTICAL_JUSTIFY"><code>CellStyle.VERTICAL_JUSTIFY</code></a></dd></dl>
</li>
</ul>
<a name="getVerticalAlignmentEnum()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getVerticalAlignmentEnum</h4>
<pre>public&nbsp;<a href="../../../../../org/apache/poi/ss/usermodel/VerticalAlignment.html" title="enum in org.apache.poi.ss.usermodel">VerticalAlignment</a>&nbsp;getVerticalAlignmentEnum()</pre>
<div class="block">Get the type of vertical alignment for the cell</div>
<dl><dt><span class="strong">Returns:</span></dt><dd>the type of alignment, default value is <a href="../../../../../org/apache/poi/ss/usermodel/VerticalAlignment.html#BOTTOM"><code>VerticalAlignment.BOTTOM</code></a></dd><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../org/apache/poi/ss/usermodel/VerticalAlignment.html" title="enum in org.apache.poi.ss.usermodel"><code>VerticalAlignment</code></a></dd></dl>
</li>
</ul>
<a name="getWrapText()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getWrapText</h4>
<pre>public&nbsp;boolean&nbsp;getWrapText()</pre>
<div class="block">Whether the text should be wrapped</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#getWrapText()">getWrapText</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html" title="interface in org.apache.poi.ss.usermodel">CellStyle</a></code></dd>
<dt><span class="strong">Returns:</span></dt><dd>a boolean value indicating if the text in a cell should be line-wrapped within the cell.</dd></dl>
</li>
</ul>
<a name="setAlignment(short)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>setAlignment</h4>
<pre>public&nbsp;void&nbsp;setAlignment(short&nbsp;align)</pre>
<div class="block">Set the type of horizontal alignment for the cell</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#setAlignment(short)">setAlignment</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html" title="interface in org.apache.poi.ss.usermodel">CellStyle</a></code></dd>
<dt><span class="strong">Parameters:</span></dt><dd><code>align</code> - - the type of alignment</dd><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#ALIGN_GENERAL"><code>CellStyle.ALIGN_GENERAL</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#ALIGN_LEFT"><code>CellStyle.ALIGN_LEFT</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#ALIGN_CENTER"><code>CellStyle.ALIGN_CENTER</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#ALIGN_RIGHT"><code>CellStyle.ALIGN_RIGHT</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#ALIGN_FILL"><code>CellStyle.ALIGN_FILL</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#ALIGN_JUSTIFY"><code>CellStyle.ALIGN_JUSTIFY</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#ALIGN_CENTER_SELECTION"><code>CellStyle.ALIGN_CENTER_SELECTION</code></a></dd></dl>
</li>
</ul>
<a name="setAlignment(org.apache.poi.ss.usermodel.HorizontalAlignment)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>setAlignment</h4>
<pre>public&nbsp;void&nbsp;setAlignment(<a href="../../../../../org/apache/poi/ss/usermodel/HorizontalAlignment.html" title="enum in org.apache.poi.ss.usermodel">HorizontalAlignment</a>&nbsp;align)</pre>
<div class="block">Set the type of horizontal alignment for the cell</div>
<dl><dt><span class="strong">Parameters:</span></dt><dd><code>align</code> - - the type of alignment</dd><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../org/apache/poi/ss/usermodel/HorizontalAlignment.html" title="enum in org.apache.poi.ss.usermodel"><code>HorizontalAlignment</code></a></dd></dl>
</li>
</ul>
<a name="setBorderBottom(short)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>setBorderBottom</h4>
<pre>public&nbsp;void&nbsp;setBorderBottom(short&nbsp;border)</pre>
<div class="block">Set the type of border to use for the bottom border of the cell</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#setBorderBottom(short)">setBorderBottom</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html" title="interface in org.apache.poi.ss.usermodel">CellStyle</a></code></dd>
<dt><span class="strong">Parameters:</span></dt><dd><code>border</code> - the type of border to use</dd><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_NONE"><code>CellStyle.BORDER_NONE</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_THIN"><code>CellStyle.BORDER_THIN</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_MEDIUM"><code>CellStyle.BORDER_MEDIUM</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DASHED"><code>CellStyle.BORDER_DASHED</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DOTTED"><code>CellStyle.BORDER_DOTTED</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_THICK"><code>CellStyle.BORDER_THICK</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DOUBLE"><code>CellStyle.BORDER_DOUBLE</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_HAIR"><code>CellStyle.BORDER_HAIR</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_MEDIUM_DASHED"><code>CellStyle.BORDER_MEDIUM_DASHED</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DASH_DOT"><code>CellStyle.BORDER_DASH_DOT</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_MEDIUM_DASH_DOT"><code>CellStyle.BORDER_MEDIUM_DASH_DOT</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DASH_DOT_DOT"><code>CellStyle.BORDER_DASH_DOT_DOT</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_MEDIUM_DASH_DOT_DOT"><code>CellStyle.BORDER_MEDIUM_DASH_DOT_DOT</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_SLANTED_DASH_DOT"><code>CellStyle.BORDER_SLANTED_DASH_DOT</code></a></dd></dl>
</li>
</ul>
<a name="setBorderBottom(org.apache.poi.ss.usermodel.BorderStyle)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>setBorderBottom</h4>
<pre>public&nbsp;void&nbsp;setBorderBottom(<a href="../../../../../org/apache/poi/ss/usermodel/BorderStyle.html" title="enum in org.apache.poi.ss.usermodel">BorderStyle</a>&nbsp;border)</pre>
<div class="block">Set the type of border to use for the bottom border of the cell</div>
<dl><dt><span class="strong">Parameters:</span></dt><dd><code>border</code> - - type of border to use</dd><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../org/apache/poi/ss/usermodel/BorderStyle.html" title="enum in org.apache.poi.ss.usermodel"><code>BorderStyle</code></a></dd></dl>
</li>
</ul>
<a name="setBorderLeft(short)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>setBorderLeft</h4>
<pre>public&nbsp;void&nbsp;setBorderLeft(short&nbsp;border)</pre>
<div class="block">Set the type of border to use for the left border of the cell</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#setBorderLeft(short)">setBorderLeft</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html" title="interface in org.apache.poi.ss.usermodel">CellStyle</a></code></dd>
<dt><span class="strong">Parameters:</span></dt><dd><code>border</code> - the type of border to use</dd><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_NONE"><code>CellStyle.BORDER_NONE</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_THIN"><code>CellStyle.BORDER_THIN</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_MEDIUM"><code>CellStyle.BORDER_MEDIUM</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DASHED"><code>CellStyle.BORDER_DASHED</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DOTTED"><code>CellStyle.BORDER_DOTTED</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_THICK"><code>CellStyle.BORDER_THICK</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DOUBLE"><code>CellStyle.BORDER_DOUBLE</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_HAIR"><code>CellStyle.BORDER_HAIR</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_MEDIUM_DASHED"><code>CellStyle.BORDER_MEDIUM_DASHED</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DASH_DOT"><code>CellStyle.BORDER_DASH_DOT</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_MEDIUM_DASH_DOT"><code>CellStyle.BORDER_MEDIUM_DASH_DOT</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DASH_DOT_DOT"><code>CellStyle.BORDER_DASH_DOT_DOT</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_MEDIUM_DASH_DOT_DOT"><code>CellStyle.BORDER_MEDIUM_DASH_DOT_DOT</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_SLANTED_DASH_DOT"><code>CellStyle.BORDER_SLANTED_DASH_DOT</code></a></dd></dl>
</li>
</ul>
<a name="setBorderLeft(org.apache.poi.ss.usermodel.BorderStyle)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>setBorderLeft</h4>
<pre>public&nbsp;void&nbsp;setBorderLeft(<a href="../../../../../org/apache/poi/ss/usermodel/BorderStyle.html" title="enum in org.apache.poi.ss.usermodel">BorderStyle</a>&nbsp;border)</pre>
<div class="block">Set the type of border to use for the left border of the cell</div>
<dl><dt><span class="strong">Parameters:</span></dt><dd><code>border</code> - the type of border to use</dd></dl>
</li>
</ul>
<a name="setBorderRight(short)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>setBorderRight</h4>
<pre>public&nbsp;void&nbsp;setBorderRight(short&nbsp;border)</pre>
<div class="block">Set the type of border to use for the right border of the cell</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#setBorderRight(short)">setBorderRight</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html" title="interface in org.apache.poi.ss.usermodel">CellStyle</a></code></dd>
<dt><span class="strong">Parameters:</span></dt><dd><code>border</code> - the type of border to use</dd><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_NONE"><code>CellStyle.BORDER_NONE</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_THIN"><code>CellStyle.BORDER_THIN</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_MEDIUM"><code>CellStyle.BORDER_MEDIUM</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DASHED"><code>CellStyle.BORDER_DASHED</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DOTTED"><code>CellStyle.BORDER_DOTTED</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_THICK"><code>CellStyle.BORDER_THICK</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DOUBLE"><code>CellStyle.BORDER_DOUBLE</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_HAIR"><code>CellStyle.BORDER_HAIR</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_MEDIUM_DASHED"><code>CellStyle.BORDER_MEDIUM_DASHED</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DASH_DOT"><code>CellStyle.BORDER_DASH_DOT</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_MEDIUM_DASH_DOT"><code>CellStyle.BORDER_MEDIUM_DASH_DOT</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DASH_DOT_DOT"><code>CellStyle.BORDER_DASH_DOT_DOT</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_MEDIUM_DASH_DOT_DOT"><code>CellStyle.BORDER_MEDIUM_DASH_DOT_DOT</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_SLANTED_DASH_DOT"><code>CellStyle.BORDER_SLANTED_DASH_DOT</code></a></dd></dl>
</li>
</ul>
<a name="setBorderRight(org.apache.poi.ss.usermodel.BorderStyle)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>setBorderRight</h4>
<pre>public&nbsp;void&nbsp;setBorderRight(<a href="../../../../../org/apache/poi/ss/usermodel/BorderStyle.html" title="enum in org.apache.poi.ss.usermodel">BorderStyle</a>&nbsp;border)</pre>
<div class="block">Set the type of border to use for the right border of the cell</div>
<dl><dt><span class="strong">Parameters:</span></dt><dd><code>border</code> - the type of border to use</dd></dl>
</li>
</ul>
<a name="setBorderTop(short)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>setBorderTop</h4>
<pre>public&nbsp;void&nbsp;setBorderTop(short&nbsp;border)</pre>
<div class="block">Set the type of border to use for the top border of the cell</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#setBorderTop(short)">setBorderTop</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html" title="interface in org.apache.poi.ss.usermodel">CellStyle</a></code></dd>
<dt><span class="strong">Parameters:</span></dt><dd><code>border</code> - the type of border to use</dd><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_NONE"><code>CellStyle.BORDER_NONE</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_THIN"><code>CellStyle.BORDER_THIN</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_MEDIUM"><code>CellStyle.BORDER_MEDIUM</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DASHED"><code>CellStyle.BORDER_DASHED</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DOTTED"><code>CellStyle.BORDER_DOTTED</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_THICK"><code>CellStyle.BORDER_THICK</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DOUBLE"><code>CellStyle.BORDER_DOUBLE</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_HAIR"><code>CellStyle.BORDER_HAIR</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_MEDIUM_DASHED"><code>CellStyle.BORDER_MEDIUM_DASHED</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DASH_DOT"><code>CellStyle.BORDER_DASH_DOT</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_MEDIUM_DASH_DOT"><code>CellStyle.BORDER_MEDIUM_DASH_DOT</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DASH_DOT_DOT"><code>CellStyle.BORDER_DASH_DOT_DOT</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_MEDIUM_DASH_DOT_DOT"><code>CellStyle.BORDER_MEDIUM_DASH_DOT_DOT</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_SLANTED_DASH_DOT"><code>CellStyle.BORDER_SLANTED_DASH_DOT</code></a></dd></dl>
</li>
</ul>
<a name="setBorderTop(org.apache.poi.ss.usermodel.BorderStyle)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>setBorderTop</h4>
<pre>public&nbsp;void&nbsp;setBorderTop(<a href="../../../../../org/apache/poi/ss/usermodel/BorderStyle.html" title="enum in org.apache.poi.ss.usermodel">BorderStyle</a>&nbsp;border)</pre>
<div class="block">Set the type of border to use for the top border of the cell</div>
<dl><dt><span class="strong">Parameters:</span></dt><dd><code>border</code> - the type of border to use</dd></dl>
</li>
</ul>
<a name="setBottomBorderColor(short)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>setBottomBorderColor</h4>
<pre>public&nbsp;void&nbsp;setBottomBorderColor(short&nbsp;color)</pre>
<div class="block">Set the color to use for the bottom border</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#setBottomBorderColor(short)">setBottomBorderColor</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html" title="interface in org.apache.poi.ss.usermodel">CellStyle</a></code></dd>
<dt><span class="strong">Parameters:</span></dt><dd><code>color</code> - the index of the color definition</dd><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../org/apache/poi/ss/usermodel/IndexedColors.html" title="enum in org.apache.poi.ss.usermodel"><code>IndexedColors</code></a></dd></dl>
</li>
</ul>
<a name="setBottomBorderColor(org.apache.poi.xssf.usermodel.XSSFColor)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>setBottomBorderColor</h4>
<pre>public&nbsp;void&nbsp;setBottomBorderColor(<a href="../../../../../org/apache/poi/xssf/usermodel/XSSFColor.html" title="class in org.apache.poi.xssf.usermodel">XSSFColor</a>&nbsp;color)</pre>
<div class="block">Set the color to use for the bottom border</div>
<dl><dt><span class="strong">Parameters:</span></dt><dd><code>color</code> - the color to use, null means no color</dd></dl>
</li>
</ul>
<a name="setDataFormat(short)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>setDataFormat</h4>
<pre>public&nbsp;void&nbsp;setDataFormat(short&nbsp;fmt)</pre>
<div class="block">Set the index of a data format</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#setDataFormat(short)">setDataFormat</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html" title="interface in org.apache.poi.ss.usermodel">CellStyle</a></code></dd>
<dt><span class="strong">Parameters:</span></dt><dd><code>fmt</code> - the index of a data format</dd><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../org/apache/poi/ss/usermodel/DataFormat.html" title="interface in org.apache.poi.ss.usermodel"><code>DataFormat</code></a></dd></dl>
</li>
</ul>
<a name="setFillBackgroundColor(org.apache.poi.xssf.usermodel.XSSFColor)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>setFillBackgroundColor</h4>
<pre>public&nbsp;void&nbsp;setFillBackgroundColor(<a href="../../../../../org/apache/poi/xssf/usermodel/XSSFColor.html" title="class in org.apache.poi.xssf.usermodel">XSSFColor</a>&nbsp;color)</pre>
<div class="block">Set the background fill color represented as a <a href="../../../../../org/apache/poi/xssf/usermodel/XSSFColor.html" title="class in org.apache.poi.xssf.usermodel"><code>XSSFColor</code></a> value.
 <p>
 For example:
 <pre>
 cs.setFillPattern(XSSFCellStyle.FINE_DOTS );
 cs.setFillBackgroundXSSFColor(new XSSFColor(java.awt.Color.RED));
 </pre>
 optionally a Foreground and background fill can be applied:
 <i>Note: Ensure Foreground color is set prior to background</i>
 <pre>
 cs.setFillPattern(XSSFCellStyle.FINE_DOTS );
 cs.setFillForegroundColor(new XSSFColor(java.awt.Color.BLUE));
 cs.setFillBackgroundColor(new XSSFColor(java.awt.Color.GREEN));
 </pre>
 or, for the special case of SOLID_FILL:
 <pre>
 cs.setFillPattern(XSSFCellStyle.SOLID_FOREGROUND );
 cs.setFillForegroundColor(new XSSFColor(java.awt.Color.GREEN));
 </pre>
 It is necessary to set the fill style in order
 for the color to be shown in the cell.</div>
<dl><dt><span class="strong">Parameters:</span></dt><dd><code>color</code> - - the color to use</dd></dl>
</li>
</ul>
<a name="setFillBackgroundColor(short)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>setFillBackgroundColor</h4>
<pre>public&nbsp;void&nbsp;setFillBackgroundColor(short&nbsp;bg)</pre>
<div class="block">Set the background fill color represented as a indexed color value.
 <p>
 For example:
 <pre>
 cs.setFillPattern(XSSFCellStyle.FINE_DOTS );
 cs.setFillBackgroundXSSFColor(IndexedColors.RED.getIndex());
 </pre>
 optionally a Foreground and background fill can be applied:
 <i>Note: Ensure Foreground color is set prior to background</i>
 <pre>
 cs.setFillPattern(XSSFCellStyle.FINE_DOTS );
 cs.setFillForegroundColor(IndexedColors.BLUE.getIndex());
 cs.setFillBackgroundColor(IndexedColors.RED.getIndex());
 </pre>
 or, for the special case of SOLID_FILL:
 <pre>
 cs.setFillPattern(XSSFCellStyle.SOLID_FOREGROUND );
 cs.setFillForegroundColor(IndexedColors.RED.getIndex());
 </pre>
 It is necessary to set the fill style in order
 for the color to be shown in the cell.</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#setFillBackgroundColor(short)">setFillBackgroundColor</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html" title="interface in org.apache.poi.ss.usermodel">CellStyle</a></code></dd>
<dt><span class="strong">Parameters:</span></dt><dd><code>bg</code> - - the color to use</dd><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../org/apache/poi/ss/usermodel/IndexedColors.html" title="enum in org.apache.poi.ss.usermodel"><code>IndexedColors</code></a></dd></dl>
</li>
</ul>
<a name="setFillForegroundColor(org.apache.poi.xssf.usermodel.XSSFColor)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>setFillForegroundColor</h4>
<pre>public&nbsp;void&nbsp;setFillForegroundColor(<a href="../../../../../org/apache/poi/xssf/usermodel/XSSFColor.html" title="class in org.apache.poi.xssf.usermodel">XSSFColor</a>&nbsp;color)</pre>
<div class="block">Set the foreground fill color represented as a <a href="../../../../../org/apache/poi/xssf/usermodel/XSSFColor.html" title="class in org.apache.poi.xssf.usermodel"><code>XSSFColor</code></a> value.
 <br/>
 <i>Note: Ensure Foreground color is set prior to background color.</i></div>
<dl><dt><span class="strong">Parameters:</span></dt><dd><code>color</code> - the color to use</dd><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFCellStyle.html#setFillBackgroundColor(org.apache.poi.xssf.usermodel.XSSFColor)"><code>)</code></a></dd></dl>
</li>
</ul>
<a name="setFillForegroundColor(short)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>setFillForegroundColor</h4>
<pre>public&nbsp;void&nbsp;setFillForegroundColor(short&nbsp;fg)</pre>
<div class="block">Set the foreground fill color as a indexed color value
 <br/>
 <i>Note: Ensure Foreground color is set prior to background color.</i></div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#setFillForegroundColor(short)">setFillForegroundColor</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html" title="interface in org.apache.poi.ss.usermodel">CellStyle</a></code></dd>
<dt><span class="strong">Parameters:</span></dt><dd><code>fg</code> - the color to use</dd><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../org/apache/poi/ss/usermodel/IndexedColors.html" title="enum in org.apache.poi.ss.usermodel"><code>IndexedColors</code></a></dd></dl>
</li>
</ul>
<a name="setFillPattern(short)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>setFillPattern</h4>
<pre>public&nbsp;void&nbsp;setFillPattern(short&nbsp;fp)</pre>
<div class="block">This element is used to specify cell fill information for pattern and solid color cell fills.
 For solid cell fills (no pattern),  foregorund color is used.
 For cell fills with patterns specified, then the cell fill color is specified by the background color.</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#setFillPattern(short)">setFillPattern</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html" title="interface in org.apache.poi.ss.usermodel">CellStyle</a></code></dd>
<dt><span class="strong">Parameters:</span></dt><dd><code>fp</code> - fill pattern (set to <a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#SOLID_FOREGROUND"><code>CellStyle.SOLID_FOREGROUND</code></a> to fill w/foreground color)</dd><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#NO_FILL"><code>CellStyle.NO_FILL</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#SOLID_FOREGROUND"><code>CellStyle.SOLID_FOREGROUND</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#FINE_DOTS"><code>CellStyle.FINE_DOTS</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#ALT_BARS"><code>CellStyle.ALT_BARS</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#SPARSE_DOTS"><code>CellStyle.SPARSE_DOTS</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#THICK_HORZ_BANDS"><code>CellStyle.THICK_HORZ_BANDS</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#THICK_VERT_BANDS"><code>CellStyle.THICK_VERT_BANDS</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#THICK_BACKWARD_DIAG"><code>CellStyle.THICK_BACKWARD_DIAG</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#THICK_FORWARD_DIAG"><code>CellStyle.THICK_FORWARD_DIAG</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BIG_SPOTS"><code>CellStyle.BIG_SPOTS</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BRICKS"><code>CellStyle.BRICKS</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#THIN_HORZ_BANDS"><code>CellStyle.THIN_HORZ_BANDS</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#THIN_VERT_BANDS"><code>CellStyle.THIN_VERT_BANDS</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#THIN_BACKWARD_DIAG"><code>CellStyle.THIN_BACKWARD_DIAG</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#THIN_FORWARD_DIAG"><code>CellStyle.THIN_FORWARD_DIAG</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#SQUARES"><code>CellStyle.SQUARES</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#DIAMONDS"><code>CellStyle.DIAMONDS</code></a>, 
<a href="../../../../../org/apache/poi/xssf/usermodel/XSSFCellStyle.html#setFillBackgroundColor(short)"><code>setFillBackgroundColor(short)</code></a>, 
<a href="../../../../../org/apache/poi/xssf/usermodel/XSSFCellStyle.html#setFillForegroundColor(short)"><code>setFillForegroundColor(short)</code></a></dd></dl>
</li>
</ul>
<a name="setFillPattern(org.apache.poi.ss.usermodel.FillPatternType)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>setFillPattern</h4>
<pre>public&nbsp;void&nbsp;setFillPattern(<a href="../../../../../org/apache/poi/ss/usermodel/FillPatternType.html" title="enum in org.apache.poi.ss.usermodel">FillPatternType</a>&nbsp;ptrn)</pre>
<div class="block">This element is used to specify cell fill information for pattern and solid color cell fills. For solid cell fills (no pattern),
 foreground color is used is used. For cell fills with patterns specified, then the cell fill color is specified by the background color element.</div>
<dl><dt><span class="strong">Parameters:</span></dt><dd><code>ptrn</code> - the fill pattern to use</dd><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFCellStyle.html#setFillBackgroundColor(short)"><code>setFillBackgroundColor(short)</code></a>, 
<a href="../../../../../org/apache/poi/xssf/usermodel/XSSFCellStyle.html#setFillForegroundColor(short)"><code>setFillForegroundColor(short)</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/FillPatternType.html" title="enum in org.apache.poi.ss.usermodel"><code>FillPatternType</code></a></dd></dl>
</li>
</ul>
<a name="setFont(org.apache.poi.ss.usermodel.Font)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>setFont</h4>
<pre>public&nbsp;void&nbsp;setFont(<a href="../../../../../org/apache/poi/ss/usermodel/Font.html" title="interface in org.apache.poi.ss.usermodel">Font</a>&nbsp;font)</pre>
<div class="block">Set the font for this style</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#setFont(org.apache.poi.ss.usermodel.Font)">setFont</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html" title="interface in org.apache.poi.ss.usermodel">CellStyle</a></code></dd>
<dt><span class="strong">Parameters:</span></dt><dd><code>font</code> - a font object created or retreived from the XSSFWorkbook object</dd><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#createFont()"><code>XSSFWorkbook.createFont()</code></a>, 
<a href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#getFontAt(short)"><code>XSSFWorkbook.getFontAt(short)</code></a></dd></dl>
</li>
</ul>
<a name="setHidden(boolean)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>setHidden</h4>
<pre>public&nbsp;void&nbsp;setHidden(boolean&nbsp;hidden)</pre>
<div class="block">Set the cell's using this style to be hidden</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#setHidden(boolean)">setHidden</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html" title="interface in org.apache.poi.ss.usermodel">CellStyle</a></code></dd>
<dt><span class="strong">Parameters:</span></dt><dd><code>hidden</code> - - whether the cell using this style should be hidden</dd></dl>
</li>
</ul>
<a name="setIndention(short)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>setIndention</h4>
<pre>public&nbsp;void&nbsp;setIndention(short&nbsp;indent)</pre>
<div class="block">Set the number of spaces to indent the text in the cell</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#setIndention(short)">setIndention</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html" title="interface in org.apache.poi.ss.usermodel">CellStyle</a></code></dd>
<dt><span class="strong">Parameters:</span></dt><dd><code>indent</code> - - number of spaces</dd></dl>
</li>
</ul>
<a name="setLeftBorderColor(short)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>setLeftBorderColor</h4>
<pre>public&nbsp;void&nbsp;setLeftBorderColor(short&nbsp;color)</pre>
<div class="block">Set the color to use for the left border as a indexed color value</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#setLeftBorderColor(short)">setLeftBorderColor</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html" title="interface in org.apache.poi.ss.usermodel">CellStyle</a></code></dd>
<dt><span class="strong">Parameters:</span></dt><dd><code>color</code> - the index of the color definition</dd><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../org/apache/poi/ss/usermodel/IndexedColors.html" title="enum in org.apache.poi.ss.usermodel"><code>IndexedColors</code></a></dd></dl>
</li>
</ul>
<a name="setLeftBorderColor(org.apache.poi.xssf.usermodel.XSSFColor)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>setLeftBorderColor</h4>
<pre>public&nbsp;void&nbsp;setLeftBorderColor(<a href="../../../../../org/apache/poi/xssf/usermodel/XSSFColor.html" title="class in org.apache.poi.xssf.usermodel">XSSFColor</a>&nbsp;color)</pre>
<div class="block">Set the color to use for the left border as a <a href="../../../../../org/apache/poi/xssf/usermodel/XSSFColor.html" title="class in org.apache.poi.xssf.usermodel"><code>XSSFColor</code></a> value</div>
<dl><dt><span class="strong">Parameters:</span></dt><dd><code>color</code> - the color to use</dd></dl>
</li>
</ul>
<a name="setLocked(boolean)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>setLocked</h4>
<pre>public&nbsp;void&nbsp;setLocked(boolean&nbsp;locked)</pre>
<div class="block">Set the cell's using this style to be locked</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#setLocked(boolean)">setLocked</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html" title="interface in org.apache.poi.ss.usermodel">CellStyle</a></code></dd>
<dt><span class="strong">Parameters:</span></dt><dd><code>locked</code> - -  whether the cell using this style should be locked</dd></dl>
</li>
</ul>
<a name="setRightBorderColor(short)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>setRightBorderColor</h4>
<pre>public&nbsp;void&nbsp;setRightBorderColor(short&nbsp;color)</pre>
<div class="block">Set the color to use for the right border</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#setRightBorderColor(short)">setRightBorderColor</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html" title="interface in org.apache.poi.ss.usermodel">CellStyle</a></code></dd>
<dt><span class="strong">Parameters:</span></dt><dd><code>color</code> - the index of the color definition</dd><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../org/apache/poi/ss/usermodel/IndexedColors.html" title="enum in org.apache.poi.ss.usermodel"><code>IndexedColors</code></a></dd></dl>
</li>
</ul>
<a name="setRightBorderColor(org.apache.poi.xssf.usermodel.XSSFColor)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>setRightBorderColor</h4>
<pre>public&nbsp;void&nbsp;setRightBorderColor(<a href="../../../../../org/apache/poi/xssf/usermodel/XSSFColor.html" title="class in org.apache.poi.xssf.usermodel">XSSFColor</a>&nbsp;color)</pre>
<div class="block">Set the color to use for the right border as a <a href="../../../../../org/apache/poi/xssf/usermodel/XSSFColor.html" title="class in org.apache.poi.xssf.usermodel"><code>XSSFColor</code></a> value</div>
<dl><dt><span class="strong">Parameters:</span></dt><dd><code>color</code> - the color to use</dd></dl>
</li>
</ul>
<a name="setRotation(short)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>setRotation</h4>
<pre>public&nbsp;void&nbsp;setRotation(short&nbsp;rotation)</pre>
<div class="block">Set the degree of rotation for the text in the cell
 <p>
 Expressed in degrees. Values range from 0 to 180. The first letter of
 the text is considered the center-point of the arc.
 <br/>
 For 0 - 90, the value represents degrees above horizon. For 91-180 the degrees below the
 horizon is calculated as:
 <br/>
 <code>[degrees below horizon] = 90 - textRotation.</code>
 </p></div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#setRotation(short)">setRotation</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html" title="interface in org.apache.poi.ss.usermodel">CellStyle</a></code></dd>
<dt><span class="strong">Parameters:</span></dt><dd><code>rotation</code> - - the rotation degrees (between 0 and 180 degrees)</dd></dl>
</li>
</ul>
<a name="setTopBorderColor(short)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>setTopBorderColor</h4>
<pre>public&nbsp;void&nbsp;setTopBorderColor(short&nbsp;color)</pre>
<div class="block">Set the color to use for the top border</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#setTopBorderColor(short)">setTopBorderColor</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html" title="interface in org.apache.poi.ss.usermodel">CellStyle</a></code></dd>
<dt><span class="strong">Parameters:</span></dt><dd><code>color</code> - the index of the color definition</dd><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../org/apache/poi/ss/usermodel/IndexedColors.html" title="enum in org.apache.poi.ss.usermodel"><code>IndexedColors</code></a></dd></dl>
</li>
</ul>
<a name="setTopBorderColor(org.apache.poi.xssf.usermodel.XSSFColor)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>setTopBorderColor</h4>
<pre>public&nbsp;void&nbsp;setTopBorderColor(<a href="../../../../../org/apache/poi/xssf/usermodel/XSSFColor.html" title="class in org.apache.poi.xssf.usermodel">XSSFColor</a>&nbsp;color)</pre>
<div class="block">Set the color to use for the top border as a <a href="../../../../../org/apache/poi/xssf/usermodel/XSSFColor.html" title="class in org.apache.poi.xssf.usermodel"><code>XSSFColor</code></a> value</div>
<dl><dt><span class="strong">Parameters:</span></dt><dd><code>color</code> - the color to use</dd></dl>
</li>
</ul>
<a name="setVerticalAlignment(short)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>setVerticalAlignment</h4>
<pre>public&nbsp;void&nbsp;setVerticalAlignment(short&nbsp;align)</pre>
<div class="block">Set the type of vertical alignment for the cell</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#setVerticalAlignment(short)">setVerticalAlignment</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html" title="interface in org.apache.poi.ss.usermodel">CellStyle</a></code></dd>
<dt><span class="strong">Parameters:</span></dt><dd><code>align</code> - - align the type of alignment</dd><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#VERTICAL_TOP"><code>CellStyle.VERTICAL_TOP</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#VERTICAL_CENTER"><code>CellStyle.VERTICAL_CENTER</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#VERTICAL_BOTTOM"><code>CellStyle.VERTICAL_BOTTOM</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#VERTICAL_JUSTIFY"><code>CellStyle.VERTICAL_JUSTIFY</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/VerticalAlignment.html" title="enum in org.apache.poi.ss.usermodel"><code>VerticalAlignment</code></a></dd></dl>
</li>
</ul>
<a name="setVerticalAlignment(org.apache.poi.ss.usermodel.VerticalAlignment)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>setVerticalAlignment</h4>
<pre>public&nbsp;void&nbsp;setVerticalAlignment(<a href="../../../../../org/apache/poi/ss/usermodel/VerticalAlignment.html" title="enum in org.apache.poi.ss.usermodel">VerticalAlignment</a>&nbsp;align)</pre>
<div class="block">Set the type of vertical alignment for the cell</div>
<dl><dt><span class="strong">Parameters:</span></dt><dd><code>align</code> - - the type of alignment</dd></dl>
</li>
</ul>
<a name="setWrapText(boolean)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>setWrapText</h4>
<pre>public&nbsp;void&nbsp;setWrapText(boolean&nbsp;wrapped)</pre>
<div class="block">Set whether the text should be wrapped.
 <p>
 Setting this flag to <code>true</code> make all content visible
 whithin a cell by displaying it on multiple lines
 </p></div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#setWrapText(boolean)">setWrapText</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html" title="interface in org.apache.poi.ss.usermodel">CellStyle</a></code></dd>
<dt><span class="strong">Parameters:</span></dt><dd><code>wrapped</code> - a boolean value indicating if the text in a cell should be line-wrapped within the cell.</dd></dl>
</li>
</ul>
<a name="getBorderColor(org.apache.poi.xssf.usermodel.extensions.XSSFCellBorder.BorderSide)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getBorderColor</h4>
<pre>public&nbsp;<a href="../../../../../org/apache/poi/xssf/usermodel/XSSFColor.html" title="class in org.apache.poi.xssf.usermodel">XSSFColor</a>&nbsp;getBorderColor(<a href="../../../../../org/apache/poi/xssf/usermodel/extensions/XSSFCellBorder.BorderSide.html" title="enum in org.apache.poi.xssf.usermodel.extensions">XSSFCellBorder.BorderSide</a>&nbsp;side)</pre>
<div class="block">Gets border color</div>
<dl><dt><span class="strong">Parameters:</span></dt><dd><code>side</code> - the border side</dd>
<dt><span class="strong">Returns:</span></dt><dd>the used color</dd></dl>
</li>
</ul>
<a name="setBorderColor(org.apache.poi.xssf.usermodel.extensions.XSSFCellBorder.BorderSide, org.apache.poi.xssf.usermodel.XSSFColor)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>setBorderColor</h4>
<pre>public&nbsp;void&nbsp;setBorderColor(<a href="../../../../../org/apache/poi/xssf/usermodel/extensions/XSSFCellBorder.BorderSide.html" title="enum in org.apache.poi.xssf.usermodel.extensions">XSSFCellBorder.BorderSide</a>&nbsp;side,
                  <a href="../../../../../org/apache/poi/xssf/usermodel/XSSFColor.html" title="class in org.apache.poi.xssf.usermodel">XSSFColor</a>&nbsp;color)</pre>
<div class="block">Set the color to use for the selected border</div>
<dl><dt><span class="strong">Parameters:</span></dt><dd><code>side</code> - - where to apply the color definition</dd><dd><code>color</code> - - the color to use</dd></dl>
</li>
</ul>
<a name="setShrinkToFit(boolean)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>setShrinkToFit</h4>
<pre>public&nbsp;void&nbsp;setShrinkToFit(boolean&nbsp;shrinkToFit)</pre>
<div class="block"><strong>Description copied from interface:&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#setShrinkToFit(boolean)">CellStyle</a></code></strong></div>
<div class="block">Controls if the Cell should be auto-sized
  to shrink to fit if the text is too long</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#setShrinkToFit(boolean)">setShrinkToFit</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html" title="interface in org.apache.poi.ss.usermodel">CellStyle</a></code></dd>
</dl>
</li>
</ul>
<a name="getCellAlignment()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getCellAlignment</h4>
<pre>protected&nbsp;<a href="../../../../../org/apache/poi/xssf/usermodel/extensions/XSSFCellAlignment.html" title="class in org.apache.poi.xssf.usermodel.extensions">XSSFCellAlignment</a>&nbsp;getCellAlignment()</pre>
<div class="block">get the cellAlignment object to use for manage alignment</div>
<dl><dt><span class="strong">Returns:</span></dt><dd>XSSFCellAlignment - cell alignment</dd></dl>
</li>
</ul>
<a name="hashCode()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>hashCode</h4>
<pre>public&nbsp;int&nbsp;hashCode()</pre>
<div class="block">Returns a hash code value for the object. The hash is derived from the underlying CTXf bean.</div>
<dl>
<dt><strong>Overrides:</strong></dt>
<dd><code>hashCode</code>&nbsp;in class&nbsp;<code>java.lang.Object</code></dd>
<dt><span class="strong">Returns:</span></dt><dd>the hash code value for this style</dd></dl>
</li>
</ul>
<a name="equals(java.lang.Object)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>equals</h4>
<pre>public&nbsp;boolean&nbsp;equals(java.lang.Object&nbsp;o)</pre>
<div class="block">Checks is the supplied style is equal to this style</div>
<dl>
<dt><strong>Overrides:</strong></dt>
<dd><code>equals</code>&nbsp;in class&nbsp;<code>java.lang.Object</code></dd>
<dt><span class="strong">Parameters:</span></dt><dd><code>o</code> - the style to check</dd>
<dt><span class="strong">Returns:</span></dt><dd>true if the supplied style is equal to this style</dd></dl>
</li>
</ul>
<a name="clone()">
<!--   -->
</a>
<ul class="blockListLast">
<li class="blockList">
<h4>clone</h4>
<pre>public&nbsp;java.lang.Object&nbsp;clone()</pre>
<div class="block">Make a copy of this style. The underlying CTXf bean is cloned,
 the references to fills and borders remain.</div>
<dl>
<dt><strong>Overrides:</strong></dt>
<dd><code>clone</code>&nbsp;in class&nbsp;<code>java.lang.Object</code></dd>
<dt><span class="strong">Returns:</span></dt><dd>a copy of this style</dd></dl>
</li>
</ul>
</li>
</ul>
</li>
</ul>
</div>
</div>
<!-- ========= END OF CLASS DATA ========= -->
<!-- ======= START OF BOTTOM NAVBAR ====== -->
<div class="bottomNav"><a name="navbar_bottom">
<!--   -->
</a><a href="#skip-navbar_bottom" title="Skip navigation links"></a><a name="navbar_bottom_firstrow">
<!--   -->
</a>
<ul class="navList" title="Navigation">
<li><a href="../../../../../overview-summary.html">Overview</a></li>
<li><a href="package-summary.html">Package</a></li>
<li class="navBarCell1Rev">Class</li>
<li><a href="class-use/XSSFCellStyle.html">Use</a></li>
<li><a href="package-tree.html">Tree</a></li>
<li><a href="../../../../../deprecated-list.html">Deprecated</a></li>
<li><a href="../../../../../index-all.html">Index</a></li>
<li><a href="../../../../../help-doc.html">Help</a></li>
</ul>
</div>
<div class="subNav">
<ul class="navList">
<li><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFCell.html" title="class in org.apache.poi.xssf.usermodel"><span class="strong">PREV CLASS</span></a></li>
<li><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFChart.html" title="class in org.apache.poi.xssf.usermodel"><span class="strong">NEXT CLASS</span></a></li>
</ul>
<ul class="navList">
<li><a href="../../../../../index.html?org/apache/poi/xssf/usermodel/XSSFCellStyle.html" target="_top">FRAMES</a></li>
<li><a href="XSSFCellStyle.html" target="_top">NO FRAMES</a></li>
</ul>
<ul class="navList" id="allclasses_navbar_bottom">
<li><a href="../../../../../allclasses-noframe.html">All Classes</a></li>
</ul>
<div>
<script type="text/javascript"><!--
  allClassesLink = document.getElementById("allclasses_navbar_bottom");
  if(window==top) {
    allClassesLink.style.display = "block";
  }
  else {
    allClassesLink.style.display = "none";
  }
  //-->
</script>
</div>
<div>
<ul class="subNavList">
<li>SUMMARY:&nbsp;</li>
<li>NESTED&nbsp;|&nbsp;</li>
<li>FIELD&nbsp;|&nbsp;</li>
<li><a href="#constructor_summary">CONSTR</a>&nbsp;|&nbsp;</li>
<li><a href="#method_summary">METHOD</a></li>
</ul>
<ul class="subNavList">
<li>DETAIL:&nbsp;</li>
<li>FIELD&nbsp;|&nbsp;</li>
<li><a href="#constructor_detail">CONSTR</a>&nbsp;|&nbsp;</li>
<li><a href="#method_detail">METHOD</a></li>
</ul>
</div>
<a name="skip-navbar_bottom">
<!--   -->
</a></div>
<!-- ======== END OF BOTTOM NAVBAR ======= -->
<p class="legalCopy"><small>
                <i>Copyright 2014 The Apache Software Foundation or
        its licensors, as applicable.</i>
            </small></p>
</body>
</html>
